Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: **PLEASE HELP** Oracle Stored Procedures question
Delphi 3.0 with BDE 4.0 does have a CURSOR type that would allow you to do this. Time to upgrade!
-Randy
P.S. Borland Tech Support is currently working on an example that should be on their web site soon(SQL Links area).
NNOOR <Nnoor_at_cris.com> wrote in article
<5lootn$lp1_at_chronicle.concentric.net>...
>
>
> 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 played with CURSOR and FETCH commands in the PL/SQL but it seems
> that Oracle fetches all of the rows before returing from the proc
> so I only get the values of the last row back in the calling routine.
>
> I will greatly appreciate any help on the topic. Oracle has a way of
> executing a SELECT and returning the result set thru a cursor, but
> Delphi does not have a CURSOR data type so I can't pass a variable as
> OUT or IN OUT to receive this cursor handle.
>
> Regards,
> --nasir (nnoor_at_cris.com)
>
Received on Sun Jun 01 1997 - 00:00:00 CDT