Troubles executing PL/SQL procedure

From: Arcadius A. <ahouans_at_sh.cvut.cz>
Date: Sat, 17 May 2003 00:50:54 +0200
Message-ID: <ba3q11$6ht$1@ns.felk.cvut.cz>

How can I run a procedure in SQLplus?
I'm using oracle 9i
See below fro error message please
<SQLplus>

SQL> CREATE OR REPLACE PROCEDURE add_categpry(

  2                v_description category.description%TYPE
  3                                        ) AS

  4 BEGIN
  5 INSERT INTO department(description)   6 VALUES(v_description);
  7 EXCEPTION
  8 WHEN OTHERS THEN
  9 DBMS_OUTPUT.PUT_LINE('An error has occured while adding a new category...');
 10 END;
 11 /

Procedure created.

SQL> exec add_category( 'maths, physics' ); BEGIN add_category( 'maths, physics' ); END;

      *
ERROR at line 1:

ORA-06550: line 1, column 7:
PLS-00201: identifier 'ADD_CATEGORY' must be declared
ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

SQL>
</SQLplus>

Thanks for helping

Arcadius A. Received on Fri May 16 2003 - 17:50:54 CDT