First stored procedure

From: kev <kevin.porter_at_fast.no>
Date: Wed, 23 Feb 2000 16:09:57 +0000
Message-ID: <38B40655.74F1DFB6@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<

Received on Wed Feb 23 2000 - 10:09:57 CST