Error

------_=_NextPart_001_01C7B7EF.C2FA609D
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

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


------_=_NextPart_001_01C7B7EF.C2FA609D--

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

RE: Re: Error

------_=_NextPart_001_01C7B805.3379CBF9
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

Hi

I have tried adding the following line to my php page. This causes the
php page to fail.

putenv("NLS_LANG=3DAMERICAN_AMERICA.WE8ISO8859P1");

I have tried adding

$oci=3Doci_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




------_=_NextPart_001_01C7B805.3379CBF9--

Re: Re: Error

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