I have an oracle function which has an out parameter which is of table rowtype as below:
CREATE OR REPLACE function retrive_emp
(
emp_id in integer;
rec_emp out tablename%rowtype;
.
.
.
I want to execute this function in php and my question is how to bind the out
.............
I tried below:
I have a boolean parameter so I used:
oci_bind_by_name($stid, ":isAbsent", $isAbsent,OCI_B_BOL );
and for the rowtype parameter I used
oci_bind_by_name($stid, ":rec_emp", $rec_emp,-1, OCI_B_BIN );
but I still get the error:
Warning: oci_execute(): ORA-06550: row 1 ، column 15 : PLS-00306: wrong number or types of arguments
Can anyone tell me what I am doing wrong?
Thanks in advance