Re: Return a dataset from a stored procedure?

Scott Dayton wrote:
>
> Does anyone know how or if a stored procedure or function can return a
> dataset similar to using select statement.
>
> ie.
> Instead of this
> SELECT * FROM EMP
> use this:
> SELECT * FROM <STORED PROCEDURE>
> --
> Regards,
> Scott Dayton

Kindly try this

select line, text from user_source where = 'TypeHereWhateverYouLike'

       order by line;

Queried table is:

SQL> desc user_source

 Name                            Null?    Type
 ------------------------------- -------- ----
 NAME                            NOT NULL VARCHAR2(30)
 TYPE                                     VARCHAR2(12)
 LINE                            NOT NULL NUMBER
 TEXT                                     VARCHAR2(2000)

Hakan Eren
InfoPower International Inc.
ERP/MRPII/DBMS Consulting and Software

Phone:905-507-2100
Fax:905-507-2108
E-mail:hakan_at_infopwr.com

       prabir_at_infopwr.com Received on Thu Jun 26 1997 - 00:00:00 CDT