ORA-06550: line 1, column 7: PLS-00201: identifier 'SMEDBS.SP_WEB_GET_PREPAID_BAL' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored in D:\PHPSite\htdocs\test.php on line 57php调用oracle存储过程报上面的错。oracle服务器是客户的机器,我没有任何权限。客户只给了我几个存储过程,但调用不成功。报这个错的原因是什么呢?存储过程没有声明?参数类型不对?php代码: $v_cust_id = 1;
$o_bal = ""; $sql_sp = "BEGIN Smedbs.sp_web_get_prepaid_bal(:v_cust_id,:o_bal); END;";
//Parse
$stmt = OCIParse($conn, $sql_sp);
OCIBindByName($stmt, ":v_cust_id",$v_cust_id,-1);
OCIBindByName($stmt, ":o_bal",$o_bal,-1);
OCIExecute($stmt);
echo $o_bal;
$o_bal = ""; $sql_sp = "BEGIN Smedbs.sp_web_get_prepaid_bal(:v_cust_id,:o_bal); END;";
//Parse
$stmt = OCIParse($conn, $sql_sp);
OCIBindByName($stmt, ":v_cust_id",$v_cust_id,-1);
OCIBindByName($stmt, ":o_bal",$o_bal,-1);
OCIExecute($stmt);
echo $o_bal;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货