Re: WEBDB form based on table created with invalid package

From: <rickloga_at_my-dejanews.com>
Date: Mon, 26 Apr 1999 20:17:00 GMT
Message-ID: <7g2hjn$249$1_at_nnrp1.dejanews.com>

In article <7fvcm1$a68$1_at_nnrp1.dejanews.com>,   rickloga_at_my-dejanews.com wrote:
> While using the WEBDB tutorial to create a form based on a table and use all
> defaults with only 2 columns I get the message that the form was created with
> invalid package. The documentation says to edit the form and correct the
> errors. How do you find the errors? When I look at the package through
> normal tools the package shows as valid. When I try to 'run' the form I get
> an error at line 1. How do you find the errors?
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
> Answer: the package was valid but some of the procedures in the package were

not valid. I used a different tool (TOAD) to compile the procedures which told me the errors which led me to seeing 2 referenced packages with the same name, one in the schema where I was compiling and one in another schema which

was granted to public.	With 2 packages of the same name and referencing them
in different schemas caused a pls-00306 error.	I dropped one of the packages

and everything worked fine. The question still is: does WEBDB have any way of showing errors? Or, do you need another tool for that?

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Apr 26 1999 - 22:17:00 CEST