Oracle 7.3 stored procedures

[Quoted] Oracle Fiends,

[Quoted] 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