Looking for examples of OCI call Oracle Stored Proc

From: Philip S Zhan <szhan_at_calum.csclub.uwaterloo.ca>
Date: 13 Jul 1999 00:15:12 GMT
Message-ID: <7me0eg$f7a$1@watserv3.uwaterloo.ca>

The only material (I have) describe the OCI interface with Oracle Stored Procedure is the OCI Programming Guide. The guide has a brief description and a piece of incomplete example code. The example is not covering my case. There is no example in Oracle's demo package.

Can someone point out some good resources (good OCI book with details) or examples.

I have a stored procedure with an array of objects or a table of objects as its parameter. I am also trying to minimize the number of server round-trips. After describing the stored proc, I got confused with so many options to deal with its parameters: ArrayOfStruct? COR? etc..

Philip

Philip Received on Mon Jul 12 1999 - 19:15:12 CDT