<Q.> Stored Procedure?
Date: 1997/11/06
Message-ID: <34617bfb.43618760_at_news.nothingbutnet.net>#1/1
[Quoted] Hello All,
[Quoted] I am a MS SQL Server developer. But now I am moving more into the Oracle realm. How do you create a simple Stored Procedure.
For example in MS you would use this:
CREATE PROCEDURE Test
AS
Select * from whatever
go
To execute:
Exec Test
Now in Oracle I tried this:
CREATE OR REPLACE PROCEDURE Test
AS
Select * from Whatever;
/
And I get PL/SQL compliation errors.
My question is who do you create a select stored procedure in Oracle. The version I am using is 7.3. I always use SP whenever possible. The Select procedure sometimes will have params and sometimes not. Could someone plesae show me an example of how to do this with Oracle..
Thanks,
Kev.- Received on Thu Nov 06 1997 - 00:00:00 CET