Re: Stored Procedure Example Needed ??

From: Kai Sodemann <Kai.Sodemann_at_memo.ikea.com>
Date: 12 Oct 1999 07:56:04 GMT
Message-ID: <01bf1490$08b9be60$6e49100a@pc910-sode.seurope.ikea.com>

Hi,

an example from the pl/sql help file:

CREATE PROCEDURE fire_employee (emp_id NUMBER) AS BEGIN
DELETE FROM emp WHERE empno = emp_id; END;

hope this helps.

reg kai

Ron Franks <Ron.Franks_at_trw.com> wrote in article <380263AC.1738793A_at_trw.com>...
> Can someone send me a simple example of a "Stored Procedure" please? I
> am on an Oracle 8.0.4 database.
>
> Thanks in advance.
>
> Ron.Franks_at_trw.com
>
>
Received on Tue Oct 12 1999 - 02:56:04 CDT