Re: First stored procedure

>I need to make use of stored procedures. Here's my first attempt (using
>SQLPlus), with errors:
>
>SQL> CREATE OR REPLACE PROCEDURE test1
> 2 (
> 3 n IN NUMBER,
> 4 m IN NUMBER
> 5 )

IS

> 6 BEGIN
> 7 INSERT INTO emp (ename, sal) values( 'testing', 1 );
> 8 END test1;
> 9 /
>
>Warning: Procedure created with compilation errors.
>
>SQL> show errors
>Errors for PROCEDURE TEST1:
>
>LINE/COL ERROR
>--------
>-----------------------------------------------------------------
>6/1 PLS-00103: Encountered the symbol "BEGIN" when expecting one of
> the following:
> ; is with authid deterministic parallel_enable as
> The symbol "is" was substituted for "BEGIN" to continue.
>
>
>This is obviously advanced Oracle-speak, I don't have a clue what it
>means. Doing a "oerr pls 103" is equally cryptic:
>
>
>[oracle8i_at_blackadder megsoc]$ oerr pls 103
>103,0, "database"
>
>
>Can someone explain please what have I done wrong? And how to fix it?
>
>TIA<
>
>- Kev
>
Received on Wed Feb 23 2000 - 10:12:52 CST