Re: how to create oracle stored procedure

From: Matt B. <mcb_at_fightspam.sd.znet.com>
Date: 2000/06/28
Message-ID: <sllfdva3jev48_at_corp.supernews.com>#1/1


Do a "show errors" to show you the errors.

<wsunarko_at_my-deja.com> wrote in message news:8je85n$9kj$1_at_nnrp1.deja.com...
> Could someone please tell me how to create a stored proc in oracle.
> I created the following from sql plus:
>
> create procedure ws_emp as
> begin
> select emp_lname
> from employee;
> end;
> /
>
> It came back with:
> Procedure created with compilation errors.
>
> TIA
> Welly
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Jun 28 2000 - 00:00:00 CEST

Original text of this message