Can anyone help. I'm trying to access an out parameter from an Oracle
Stored Procedure. But I get the following message. I think it might have
something to do with the configuration of our server but I'm not sure.

Warning: ociexecute(): OCIStmtExecute: ORA-06550: line 1, column 20:
PLS-00553: character set name is not recognized ORA-06550: line 0,
column 0: PL/SQL: Compilation unit analysis terminated in
on line 23

The code is below



$c = oraconnect();

 // Create database procedure...
  $s = OCIParse($c, "create procedure proc1(p2 OUT number) as " .
                    "begin" .
                    "  p2 := 10 + 10;" .
  OCIExecute($s, OCI_DEFAULT);

  // Call database procedure...
  $s = OCIParse($c, "begin proc1(:bind2); end;");
     die("Problem with passing the SQL. Unable to parse the Oracle
query. Please try something else.\n");
  OCIBindByName($s, ":bind2", $out_var, 32); // 32 is the return length

  $orares = ociexecute($s);
  die("Problem with EXECUTING the SQL. Unable to execute the Oracle
query. Please try something else.\n");
                   $oerr = OCIError();
                   if ($oerr['message']){
                                 echo " The error is<br>$oerr[message]";
  echo "Procedure returned value: " . $out_var;

  // Logoff from Oracle...

David Skyers
Support Analyst
Management Systems, EISD, UCL
Extension: 41849
Tel: 020 7679 1849

Reply via email to