<Q.> Stored Procedure?

From: KevSter <kev_at_kconcept.com>
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

Original text of this message