Thies C. Arntzen wrote:

On Mon, Nov 04, 2002 at 06:16:04PM +0100, Fabien JOSEPH wrote:

I discovered recently that it was impossible to bind an output
placeholder plsql (an input work only).

Configuration 1 : Suse + Oracle 8i17 + oci (oracle) + PHP4.2.3
Configuration 2 : HPUX11 + Oracle 8i17 + oci(oracle) + PHP4.2.3
Configuration 3 : HPUX11 + Oracle 8i17 + oci(oracle) + PHP4.2.2

With script :
CREATE OR REPLACE PROCEDURE inoutdemo (par_in IN VARCHAR2, par_in_out IN
OUT VARCHAR2, par_out OUT VARCHAR2) IS BEGIN par_out:=par_in; par_in_out:=par_in||' '||par_in_out; END;

$db=OCILogon("toto","titi"); $stmt=OCIParse($db,"BEGIN inoutdemo(:in,:inout,:out);END;");
OCIBindByName($stmt,":out",$out,32); $in="Hello "; $inout="World!"; OCIExecute($stmt); echo $in."\n".$inout."\n".$out."\n";

Warning: OCIStmtExecute: ORA-06550: line 1, column 17: PLS-00553:
character set name is not recognized ORA-06550: line 0, column 0:


i'd say you have a problem with your NLS_LANG setting.

PL/SQL: Compilation unit analysis terminated in
/opt/apache/htdocs/fab.php4 on line 58
Hello World!
I tested this script with the 3 configurations but it's the same error

I changed $in, &inout , &out into $&in, $&out, $&inout but it's the same

Please help me !!!


PHP Database Mailing List (
To unsubscribe, visit:

Thank you for your help but finally I resolved my problem. It was my compilation of php.
Before my compilation of phpI, forgot to set LD_LIBRARY_PATH to $ORACLE_HOME/lib.

Recently, I compiled again my php but this time I set LD_LIBRARY_PATH before the compilation.

And finally when I finished to compile my php, I test my script again and it's work.


PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to