下面的代码执行失败,提示:
warning:Ora_Bind failed(ORA-01036:illegal variable name/number ...)
各位高手帮帮忙,请问如何修改正确,谢谢!<?php
$conn = ora_plogon("admin@test","123");
$a="201007";
$b="sys";
$sql="declare v1 number;v2 varchar2(50); begin proc('".$a."','".$b."',v1,v2); end;");
$curs = ora_open($conn);
ora_parse($curs,$sql) or die;
ora_bind($curs, "output1", "v1", 8, 2);
ora_bind($curs, "output2", "v2", 50, 2);
ora_exec($curs);
?>
warning:Ora_Bind failed(ORA-01036:illegal variable name/number ...)
各位高手帮帮忙,请问如何修改正确,谢谢!<?php
$conn = ora_plogon("admin@test","123");
$a="201007";
$b="sys";
$sql="declare v1 number;v2 varchar2(50); begin proc('".$a."','".$b."',v1,v2); end;");
$curs = ora_open($conn);
ora_parse($curs,$sql) or die;
ora_bind($curs, "output1", "v1", 8, 2);
ora_bind($curs, "output2", "v2", 50, 2);
ora_exec($curs);
?>
顶。
$conn = ora_plogon("admin@test","123");
$a="201007";
$b="sys";
$sql="begin proc('".$a."','".$b."',:v1,:v2); end;");
$curs = ora_open($conn);
ora_parse($curs,$sql) or die;
ora_bind($curs, "output1", ":v1", 8, 2);
ora_bind($curs, "output2", ":v2", 50, 2);
$output1=null;
$output2=null;
ora_exec($curs);
?>