Re: Troubles executing PL/SQL procedure

On Sat, 17 May 2003 00:50:54 +0200, "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
><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.
>

Please *read* your own post *CAREFULLY* and don't ask for assistance with a TYPO. The purpose of this group is not to debug code or to iron out typos

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun May 18 2003 - 05:56:22 CDT