Posted by Jose Angel Sanchez on 02/21/05 11:22

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...

[Back to original message]