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