Re: Help on developer 2000

You need to use <package name>.<procedure name> if you want to use the procedure from the package.
I would like to advise you, you need to make your procedure names a bit more different. Soon you will fall in the trap you set up for yourself. This is one of the reasons why you need to qualify with the package name.

Hth,

--
Sybrand Bakker, Oracle DBA
Tom Deseamus <tdeseamus_at_digital-hire.com> wrote in message news:aBR74.33927$Dk.440801_at_news1.mia...
> Newbie question:
>
> I've set up a package spec, package body with one procedure and one
separate
> procedure:
>
> Package Spec
>
> PACKAGE UPDATE_PRODUCT IS
> END;
>
> Package Body
>
> PACKAGE BODY UPDATE_PRODUCT IS
> procedure UP_PRODUCT is
> BEGIN
> UPDATE PRODUCT
> SET DESCRIPTION = 'TEST'
> WHERE
> PRODUCT_ID = 100890;
> END;
>
> END;
>
>
> Procedure
>
> PROCEDURE UPROD IS
> BEGIN
> UPDATE PRODUCT
> SET DESCRIPTION = 'TEST'
> WHERE
> PRODUCT_ID = 100890;
> END;
>
>
> All information is stored in the schema DEMO. I try to run the procedure
> UP_PRODUCT as follows and get the error message below.
>
> SQL> EXECUTE UP_PRODUCT;
>
> BEGIN UP_PRODUCT; END;
>
> *
> ERROR at line 1:
> ORA-06550: line 1, column 7:
> PLS-00201: identifier 'UP_PRODUCT' must be declared
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
>
> SQL>
>
>
>
>
>
>
>
> When I try to run the procedure uprod, I get the following error.
>
> SQL> execute uprod;
> BEGIN uprod; END;
>
> *
> ERROR at line 1:
> ORA-06550: line 1, column 7:
> PLS-00201: identifier 'UPROD' must be declared
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
>
> SQL>
>
> Any help would be greatly appreceated
>
>
>
Received on Tue Dec 21 1999 - 16:22:18 CST