Home -> Usenet -> comp.databases.oracle -> Getting Oerr –03106 When Sorted function is called from OCI application

Getting Oerr –03106 When Sorted function is called from OCI application

From: Anuruddha <himanu_at_yahoo.com>
Date: 17 Apr 2002 04:50:23 -0700
Message-ID: <285b226f.0204170350.17bc25b9_at_posting.google.com> 






Hi



I am using OCI V8 to execute a stored function in oracle 8.1.5
database. A ref type cursor is returned from the function as a IN OUT
parameter. The function header is given bellow.


 GET_IDS(P_CURSOR	IN OUT CURSORTYPE,
	P_CLIENT_ID	IN VARCHAR2,
	P_REJ_REASON			OUT VARCHAR2,
	P_ACCEPTED				OUT NUMBER
	) RETURN VARCHAR2 





With in the OCI program &#8220;OCISTMTExecute()&#8221;, is called in a
loop. At the first iteration every thing works fine. But in the second
iteration when &#8220;OCISTMTExecute()&#8221; is called OERR
&#8211;03106 error is returned.



But when the P_ACCEPTED in the stored function is changed in to a
varchar variable oci program works with out any trouble.



Does any one know a solution for this ?
Received on Wed Apr 17 2002 - 13:50:23 CEST












Original text of this message