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
精彩评论