Re: Help on procedure builder

[Quoted] To use a procedure in a package, you must export it in the specification.

Tom Deseamus wrote:
>
> 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 Wed Dec 22 1999 - 01:19:51 CET