Re: WEBDB form invalid package

In article <7g0353$ssf$1_at_nnrp1.dejanews.com>,   rickloga_at_my-dejanews.com wrote:
> When creating a webdb (2.0.5.7.1) form from table I get a PLS-00306 error on
> the normalize procedure in the webdb.wwv.name_values package. Any ideas why?
> The package is granted to public and the 4 arguments to the procedure have
> the last 2 arguments defaulted so just passing 2 arguments should work and
> they are of the same type (owa.vc_arr). I also get the same error on other
> procedures in that package (e.g. check_defaults) but yet other procedures get
> no errors.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
> Answer: The owa package was in 2 schemas and one was public. The non-public

one was in the schema where the compile was taking place and it referenced a package in another schema that referenced the public owa package. The solution was to drop the non-public packages as it was a duplicate anyway. (Found a few other duplicate packages also!).

-----------== 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:20:33 CEST