Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Troubles executing PL/SQL procedure

Re: Troubles executing PL/SQL procedure

From: Ubiquitous <weberm_at_polaris.net>
Date: Tue, 20 May 2003 14:45:38 +0000 (UTC)
Message-ID: <badf2i$kn3$1@news.utelfla.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US