Re: Newbie Question: Simple Stored Procedure

You need to
either give up mssql habits
or use a ref cursor
Refer to http://osi.oracle.com/~tkyte/ResultSets/index.html or the Oracle docs.

Hth,

Sybrand Bakker, Oracle DBA

Louis <frolio_at_videoshare.com> wrote in message news:8c06pi$ad4$1_at_bob.news.rcn.net...
> Greeting All, I have a table schema.table which has
> many rows of data. I want to write a simple stored
> procedure that will pull all the rows from this table;
>
> create or replace procedure schema.procedure
> as
> begin
> select * from schema.table
> end;
> /
>
> When I run the above script I get all kinds of compilation
> errrors?? Can anyone help me with the above procedure?
>
> Much Thanks, Louis
> frolio_at_videoshare.com
>
>
Received on Thu Mar 30 2000 - 12:52:08 CST