dqrb4228 2014-01-14 13:21
浏览 112
已采纳

oci_bind_by_name:PHP致命错误:只能通过引用传递变量

I'm trying to call a function from an Oracle package and I'm getting this error:

PHP Fatal error: Only variables can be passed by reference

This is my code:

    $connection = $this->getConnection();

    if (!$connection){
        return null;
    }

    $s = oci_parse($connection, "begin my_package.my_function(
            :param1
        ); end;");

    //getting the error in this following line:
    oci_bind_by_name($s, ":param1", "13")


    if($result = oci_execute($s)){
             ....
    }
    ...

I've been looking at other posts with this exactly same error but none of them seem to be related with this issue.

I'm using PHP version 5.5.6 over IIS 7.5 in a Windows 7 machine.

This is the definition of the function at my pacakage:

FUNCTION my_function(param1 IN VARCHAR2) RETURN CLOB IS
BEGIN
-- etc...
-- etc...
END;
  • 写回答

1条回答 默认 最新

  • douzhan1935 2014-01-14 13:28
    关注

    Third parameter of oci_bind_by_name is passed by reference, hence you need to store it in a variable first:

    $param1 = "13";
    oci_bind_by_name($s, ":param1", $param1);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 乘性高斯噪声在深度学习网络中的应用
  • ¥15 运筹学排序问题中的在线排序
  • ¥15 关于docker部署flink集成hadoop的yarn,请教个问题 flink启动yarn-session.sh连不上hadoop,这个整了好几天一直不行,求帮忙看一下怎么解决
  • ¥30 求一段fortran代码用IVF编译运行的结果
  • ¥15 深度学习根据CNN网络模型,搭建BP模型并训练MNIST数据集
  • ¥15 C++ 头文件/宏冲突问题解决
  • ¥15 用comsol模拟大气湍流通过底部加热(温度不同)的腔体
  • ¥50 安卓adb backup备份子用户应用数据失败
  • ¥20 有人能用聚类分析帮我分析一下文本内容嘛
  • ¥30 python代码,帮调试,帮帮忙吧