开发者

Calling oracle procedures through zend framework

I am calling a stored procedure that has 2 input parameters (id,name) and 2 output parameters (year, value) from a zend framework.

If the output parameters are of type NUMBER then I am able to bind and run the procedure. But in my case the output parameters are of "TYPE" table. I have created the type like this:

CREATE OR REPLACE TYPE year IS TABLE OF NUMBER(4);
CREATE OR REPLACE TYPE  value IS TABLE OF NUMBER(10,3);

I am calling the procedure in php like this:

$callProc = "CALL proc_name($idValue,$nameValue,:o_years,:o_value)";
$stmt = $this->_DB->prepare($callProc);

I am having problem in trying to bind the output variable o_years and o_value usin开发者_运维知识库g bindParam() since it is a type and not string.


oci_new_cursor should help

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜