Additional
dbCAP
AnyDAC
ThinDAC
NCOCI8
Topic: Stored Procedure
Stored Procedure
Posted: 2000/06/22 18:37
 
Can I create a stored procedure? What would I use (OCIQuery?).
How can I get a result set from OCIStoredProc except for creating a temp table?
RE: Stored Procedure
Posted: 2000/06/22 20:17
 
Hi Roland !

You have two options:
- use of TOCIStoredProc, and that is most convenient path;
- use of TOCIQuery and PL/SQL anonymous block as content of SQL property.
To get result set from stored proc see RefCursor demo from v 0.8.0. If you will have additional questions let me know.