Re: Oracle 7.3 stored procedures

Hi, Ricardo!

This is PL/SQL (just have a look on the error number), thus you have to use an INTO... ;-) You will need to use a cursor to obtain a resultset.

Günther

ricaze wrote:

> Oracle Fiends,
>
> I got stuck in a very basic store procedure and need some
> help. It goes like this:
>
> CREATE OR REPLACE PROCEDURE test
> is
> begin
> select * from MyTable;
> end;
>
> and the bastard engine say "You need an INTO clause."
>
> If I store it in a variable, it means that I will only be
> able to return a value and I was keen in getting a
> resultset.
>
> Any Ideas?
>
> Thanks
> Ricaze (ricardo_j_carvalho_at_hotmail.com)
>
> * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful
Received on Mon May 15 2000 - 00:00:00 CEST