I want to create a stored procedure for
SELECT * from MYTABLE
When I use BEGIN & END command, Oracle asked me using INTO.
I don't want to INTO some table, but only display it on the screen.
When I don't use BEGIN & END with SQL Plus 8.0, I got the message:
PLS-00103: Encountered the symbol "SELECT" when expecting one of
the following:
begin function package pragma procedure subtype type use ...
Someone told me I must use a cursor to select only one record each time
and
use INTO.
I can't believe it, because I can do it very easily with Microsoft SQL
Server.
Please tell me what is wrong to frankmeng_at_usa.net
Thanks in advance.
Frank
Received on Tue Nov 24 1998 - 08:45:06 CST
