Hi everybody.. I have two servers: LINUX DEBIAN WEB SERVER (apache, php, oracle client) and LINUX REDHAT ADVANCED SERVER (Oracle Database Server) I can execute all kind of basic sql from php to oracle, it works fine except accents and symbol of html's ñ (I'm Spanish) But the problem comes when I try to call a stored procedure using variable binding: $db_conn = ocilogon ($GLOBALS["User"], $GLOBALS["Password"],$GLOBALS["DatabaseName"]); $cmdstr = 'begin MyPackage.MyProcedure(:var1, :var2); end;'; $parsed = ociparse($db_conn, $cmdstr); OCIBindByName($parsed,':var1',$firstVar); OCIBindByName($parsed,':var2',$secondVar); OCIExecute($parsed,OCI_DEFAULT); Output error: Warning: ociexecute(): OCIStmtExecute: ORA-06550: line 1, column 30: PLS-00553: character set name is not recognized ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated in /var/www/test.php on line 913 Column 29 is ':' character. I have been looking for solutions all around the whole web and many forums, setting environment variables like NLS_LANGUAGE and others... on linux, apache and php, but the same. Does anybody know what must I exactly set on system or code to make it works? I'have this problem from 2 months ago to now, and nobody knows how to do!! (except any of you, I wish). Thx for reading... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
