Re: <Q.> Stored Procedure?

[Quoted] I tried that also and still the same errors.

The statement I used is:

create procedure test
  as
   begin
    select * from whatever;
   end;
/

and

create procedure test
  as
   begin
    select * from whatever;
   end
/

and

create procedure test
  as
   begin
    select * from whatever
   end
/

I just do not get it.

On Thu, 06 Nov 1997 19:45:48 -0800, czetie_at_nospamus.oracle.com wrote:

>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 Fri Nov 07 1997 - 00:00:00 CET