Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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
![]() |
![]() |