Re: PL/SQL with OCI Help

In article <3gobh6$r3d_at_welby.ahc.ameritech.com>, Abbas Asadi <aasadi_at_tejas.kdsi.com> wrote:
>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.
>

Problem #1:  You're using Oracle; you should use Sybase.
Problem #2:  You're using Oracle; you *definitely* should use Sybase.
Problem #3:  You're using out-dated technology called Oracle.

Have a nice day.

• Bob