Stored Procedures in OCI programs
From: Karla Dods <sticklan_at_bnr.ca>
Date: 1 Sep 1994 19:36:54 GMT
Message-ID: <345agm$n03_at_bcarh8ab.bnr.ca>
Date: 1 Sep 1994 19:36:54 GMT
Message-ID: <345agm$n03_at_bcarh8ab.bnr.ca>
Were having great difficulty programming with OCI trying to execute a stored procedures which is a select statement which returns data. Currently we are receiving the following message: ORA-06502: PL/SQL: numeric or value error
The PL/SQL is as follows:
BEGIN procname.proc_1(:p0,:p1,:p2); END;
The first two fields are not null input number variables
The third field is a char(8) output varible.
Data is correct in the input variables and are not truncated.
Any examples of OCI executing a SELECT database procedure which returns rows, would be most helpful.
Thanks,
Karla Dods Received on Thu Sep 01 1994 - 21:36:54 CEST