Try to put an "IS" before begin.
I think the syntax is:
CREATE OR REPLACE PROCEDURE test1 (n IN NUMBER, m IN NUMBER ) IS
BEGIN
.........
END;
/
kev <kevin.porter_at_fast.no> wrote in message
news:38B40655.74F1DFB6_at_fast.no...
> Hi,
>
> 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 )
> 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:14:25 CST
