Re: **PLEASE HELP** Oracle Stored Procedures question

NNOOR wrote:
>
> I have many complex queries in my client app which I would like to
> have stored on the server side to cut down on many time/resource
> intensive variables.
>
> All of these queries return multiple rows as result set.
>
> I am using Delphi 2.0 C/S and Oracle WGS 7.3 (NT v4.0).
>
> I can't seem to figure out how to return a result set from the
> Oracle stored procedures. Oracle doesn't allow use of SELECT on
> the stored procs. Delphi does not have a CURSOR data type that I
> could use as an OUT parameter. So, I am lost here.
>

I have tried to pull this off as well but was unable to figure out a way to make it work. If you do find out how, please let me know. Received on Mon May 19 1997 - 00:00:00 CDT