PL/SQL with OCI Help

From: Abbas Asadi <aasadi_at_tejas.kdsi.com>
Date: 1 Feb 1995 16:05:58 GMT
Message-ID: <3gobh6$r3d_at_welby.ahc.ameritech.com>

I am working on a project (ORACLE7 with PL/SQL extension) which executes a stored procedure on the server and return the results (if any) to users. This is being done in a C interface. The problem is that I do not know if I have to call "ofetch" after "oexec" or not. How do I know if this stored procedure (dynamically supplied by user at run time) returns any row or not. SYBASE has an easy way (a simple dblib call) indicatiny if the SP returns any row(s).

I' ll appreciate any suggestion/help/C example.

aasadi_at_texas.akd
(214) 301-6142 Received on Wed Feb 01 1995 - 17:05:58 CET

This message: [ Message body ]
Next message: Tom Mize: "Why is bytes not = initial extent when extents = 1 in seg view"
Previous message: flachan_at_ibm.net: "What TCP/IP stack works with SQL*TCP"
Next in thread: Robert Gibbons: "Re: PL/SQL with OCI Help"
Reply: Robert Gibbons: "Re: PL/SQL with OCI Help"
Reply: Scott Urman: "Re: PL/SQL with OCI Help"
Reply: Dennis Harvey: "Re: PL/SQL with OCI Help"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message