Re: Help on procedure builder

Thank you, but exactly how do you "export" it in the specification.

Phung Hoang-Vu <hoang-vu_at_freesurf.ch> wrote in message news:38601927.A60917BB_at_freesurf.ch...
> 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 - 02:45:56 CET