$tns = "(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = {$datas['hostname']})(PORT = {$datas['hostport']})))(CONNECT_DATA =(SERVICE_NAME = {$datas['database']})))";
$db = oci_connect($datas['username'], $datas['password'], $tns, 'UTF8');
if (!$db) return false;
//调用存储过程
$batchNumber = time() . rand(1000, 9999);
$stmt = oci_parse($db, "call {$datas['function_name']}(:batchNumber,:param,:code,:msg,:data)");
//输入参数
oci_bind_by_name($stmt, ":batchNumber", $batchNumber, 500);
oci_bind_by_name($stmt, ":param", $param, 500);
//输出参数
oci_bind_by_name($stmt, ":code", $code, 32);
oci_bind_by_name($stmt, ":msg", $msg, 200);
oci_bind_by_name($stmt, ":data", $data, 200);
oci_execute($stmt);
return ['return_code' => $code, 'return_msg' => $msg, 'return_data' => $data];一开始使用的pdo_oci 可以请求到存储过程 入参也正常 但是出参怎么也获取不到 最后在php官网看到 pdo_oci扩展最后一次更新时间是在2005年 可以说已经废弃了解决方案:使用oci8链接oracle就正常了
最佳答案
