Re: DOES ANYBODY KNOW THE ANSWER TO THIS QUESTION?????

Adam F. Kelley wrote:
>
> I am trying to figure out how to pass multiple results from a stored
> procedure to a client ODBC app.
>
> For example :
>
> CREATE or REPLACE PROCEDURE WhatEver
> AS
> BEGIN
> SELECT * FROM Table ;
> END;
>
> I can perform these types of stored procs. in other RDBMS's (eg MS-SQL,
> Sybase). I have heard from a few sources that this type of stored proc.
> is not possible under Oracle, on the other hand I have heard from other
> sources that there is a way of doing this sort of thing (Of course those
> same people can't tell me how...). I need to be able to call Oracle
> stored procs. from custom client apps. as well as SW-Apps. like Crystal
> Report Writer. It needs to be able to return multiple rows of data.
>
> Anybody that has any suggestions on this subject, I would certainly
> appprecitate hearing from you.
>
> Thnx,
>
> AFK
Hi,

if you intend to do something like Access's querires can do then you'll be dissapointed 'cause Oracle won't to this.

-- 
Regards

Matthias Gresz    :-)