Oracle Stored Procedures again!

wxdqz

New Member
Hi,

I磎 sorry to sending another post about this subject... but I tried every tip and I can磘 make this SP work...

I type this on SQL Plus and it work fine:

SQL> var x varchar2(10);
SQL> exec :x := cpf(26852842819);

PL/SQL procedure successfully completed.

SQL> print x;

X
--------------------------------
1

but my PHP:

<?

$c=OCILogon("SYSTEM","manager");
$x =0;
$cpf="10001628852";

$sth = OCIParse ($c, "begin CPF_ORA( :$cpf, :$x );end;" );

OCIBindByName ( $sth, ":cpf", $cpf, 11 );
OCIBindByName ( $sth, ":x", $x, 10 );

OCIExecute ($sth );

?>

returns the following error message:

Warning: OCIBindByName: ORA-01036: nome/n鷐ero de vari醰el inv醠ido in c:
\program files\apache group\apache\htdocs\testes\procedure4.php on line 10

Warning: OCIBindByName: ORA-01036: nome/n鷐ero de vari醰el inv醠ido in c:
\program files\apache group\apache\htdocs\testes\procedure4.php on line 11

Warning: OCIStmtExecute: ORA-01008: nem todas as vari醰eis s鉶 limitadas in
c:\program files\apache group\apache\htdocs\testes\procedure4.php on line
13

can anybody help me???

thanks everyone!

JB
 
Back
Top