duandao6414 2019-06-03 15:26
浏览 67

php存储过程调用不返回输出

I have this weird issue. during this pecific stored procedure call. it does not return any output.

$errorcode = 0;
$errortext = '';
//$purge = false;
$sql = "BEGIN ".DBUSER.".PKGCCPEX.INSERT_POLICIES(:O_ERRORCODE, :O_ERRORTEXT, :I_EXEMPTION_ID, :I_COMMS_MATRIX_ID); END;";
$db_rw->parse($sql);
$result2 =  $db_rw->getStatement();
oci_bind_by_name($result2, ':O_ERRORCODE', $errorcode, 10, SQLT_INT);
oci_bind_by_name($result2, ':O_ERRORTEXT', $errortext, 100, SQLT_CHR);
oci_bind_by_name($result2, ':I_EXEMPTION_ID', $model->fieldVals['ID'], 10, SQLT_INT);
oci_bind_by_name($result2, ':I_COMMS_MATRIX_ID', $model->fieldVals['COMMS_MATRIX_ID'], 10, SQLT_INT);
//oci_bind_by_name($result2, ':I_PURGE', $purge, 1, SQLT_INT);
db_query_execute($result2);

I run the procedure in oracle and it works fine. when i run it via php $errortext is always empty.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 delta降尺度计算的一些细节,有偿
    • ¥15 Arduino红外遥控代码有问题
    • ¥15 数值计算离散正交多项式
    • ¥30 数值计算均差系数编程
    • ¥15 redis-full-check比较 两个集群的数据出错
    • ¥15 Matlab编程问题
    • ¥15 训练的多模态特征融合模型准确度很低怎么办
    • ¥15 kylin启动报错log4j类冲突
    • ¥15 超声波模块测距控制点灯,灯的闪烁很不稳定,经过调试发现测的距离偏大
    • ¥15 import arcpy出现importing _arcgisscripting 找不到相关程序