Stored procedure with NOT PL/SQL
From: Frank Meng <frankmeng_at_usa.net>
Date: Tue, 24 Nov 1998 14:42:17 GMT
Message-ID: <365AC5C8.D9E8168_at_usa.net>
[Quoted] I want to create a stored procedure for SELECT * from MYTABLE
[Quoted] 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 - 15:42:17 CET
Date: Tue, 24 Nov 1998 14:42:17 GMT
Message-ID: <365AC5C8.D9E8168_at_usa.net>
[Quoted] I want to create a stored procedure for SELECT * from MYTABLE
[Quoted] 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 - 15:42:17 CET