Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Reusing a cda with OCI
Hi,
I'm a little bit confused about reusing cursors and cdas with OCI.
Using OCI, I'm doing the following:
I seem to be reusing the command CDA sucessfully. I'd like to be able to reuse the PROC_CDA by passing the same PROC_CDA to each stored proc that I'm calling. I haven't been able to get it to work, and I haven't found any examples of doing this.
Can anyone tell me if it is possible to reuse a cda which is passed as an IN OUT param and opened from a PL/SQL stored proc with a regular OPEN cursor FOR statement? What are the implications of using a DBMS_SQL open cursor command?
Thanks for your help,
Brenda Muller Received on Mon Mar 09 1998 - 00:00:00 CST