Re: Troubles executing PL/SQL procedure

Arcadius A. <ahouans_at_sh.cvut.cz> wrote:

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

Did you misspell your procedure someplace? :-)

: 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 Tue May 20 2003 - 09:45:38 CDT