Re: Help on developer 2000

From: Tom Deseamus <tdeseamus_at_digital-hire.com>
Date: Tue, 21 Dec 1999 16:56:43 -0600
Message-ID: <5CT74.2992$Dj6.56994@news2.mia>

Thanks for the help, but that did not seem to work either. Here are the results:

SQL> execute update_product.up_product; BEGIN update_product.up_product; END;

      *
ERROR at line 1:

ORA-06550: line 1, column 7:
PLS-00201: identifier 'UPDATE_PRODUCT.UP_PRODUCT' must be declared
ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

SQL> It seems like I have to declare up_product somewhere? The spec, body and other procedure are all stored in the database DEMO. I am logging onto SQL + as demo. Don't know what else to do.

Thanks, again.

Sybrand Bakker <postmaster_at_sybrandb.demon.nl> wrote in message news:945815001.765.0.pluto.d4ee154e_at_news.demon.nl...
> 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:56:43 CST