Re: <Q.> Stored Procedure?

KevSter wrote:
>
> Hello All,
>
> 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.-

you need a BEGIN and END; pair around the body. Received on Thu Nov 06 1997 - 00:00:00 CET