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@xxxxxxxxxxxxx]
Sent: 26 June 2007 16:09
To: php-db@xxxxxxxxxxxxx
Subject: 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
