[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-db
Subject:    Re: [PHP-DB] Re: Error
From:       165.123.57.126
Date:       2007-06-26 15:24:57
Message-ID: 24.30.55648.CCF21864 () pb1 ! pair ! com
[Download RAW message or body]

putenv() never works well with oracle vars. They need to be set for the
account running the web server. When the web server starts, it will
inherit the oracle vars from the environment.

David Skyers wrote:
> Hi
> 
> I have tried adding the following line to my php page. This causes the
> php page to fail.
> 
> putenv("NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1");
> 
> I have tried adding
> 
> $oci=oci_pconnect($user, $pass, $db,'WE8ISO8859P1');
> 
> I don't believe the error is due to character sets. I believe it is a
> problem with binding parameter to oracle procedures in php.
> If I remove the binding the procedure works. If I add it it fails.
> 
> Any ideas
> 
> David
> 
> -----Original Message-----
> From: Roberto Mansfield [mailto:robertom@sas.upenn.edu]
> Sent: 26 June 2007 16:09
> To: php-db@lists.php.net
> Subject: [PHP-DB] Re: Error
> 
> This could be a problem with your ORACLE_HOME and/or NLS_LANG
> environment variables. These need to be set for your user account
> running the web server BEFORE the web server is started. Don't try to
> set these in your php script or you'll get strange results.
> 
> David Skyers wrote:
>> Hi
>>
>> I have a page that inserts data into a oracle table using a oracle
>> stored procedure via php. However when the php runs I get the
>> following
>> error:
>>
>> Warning: oci_execute() [function.oci-execute]: ORA-06550: line 2,
>> column
>> 7: PLS-00553: character set name is not recognized ORA-06550: line 0,
>> column 0: PL/SQL: Compilation unit analysis terminated in
>> /nfs/rcs/www/webdocs/research/rsr/staff/dev/rae-mypubs1.php on line
>> 121
>>
>> Does anyone know why this is occurring?
>>
>> Regards
>>
>> David
>>
>>
> 
> --
> PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:
> http://www.php.net/unsub.php
> 
> 
> 
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[prev in list] [next in list] [prev in thread] [next in thread]