Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: plsxml setup yields errors with checkdeps.sql
"Frank" <fvanbortel_at_netscape.net> wrote in message
news:3E4C0263.1050508_at_netscape.net...
> Bill Lucas wrote:
> > Hello all,
> >
> > Here is a screen shot of the info I get back when running checkdeps.sql
on
> > our Oracle Server Version information included in screen shot
> >
> > Connected to:
> > Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> > With the Partitioning option
> > JServer Release 8.1.7.0.0 - Production
> >
> > SQL> @checkdeps.sql
> > DECLARE
> > *
> > ERROR at line 1:
> > ORA-06502: PL/SQL: numeric or value error
> > ORA-06512: at "SYS.OWA_UTIL", line 315
> > ORA-06512: at "SYS.HTP", line 859
> > ORA-06512: at "SYS.HTP", line 974
> > ORA-06512: at "SYS.HTP", line 992
> > ORA-06512: at line 10
> >
> > Can anyone help with these errors? Am I missing something? Oracle is
still
> > a foreign entity to me, and I will freely admit my ignorance in this
case.
> >
> > Can anyone point me in a direction to try?
> >
> > For the interested we are starting to rewrite our application for an
oracle
> > backend. We are currently investigating the various methods of getting
xml
> > out of an oracle database. We are still ruinning against 8i and are
> > planning on developing to that platform. We can not use 9i as our
customer
> > surveys indicated most are still running 8.x.x and are reluctant to
upgrade
> > to 9i. So if there are better ways to get XML out of the database
please
> > let me know... One of the things the dbxml package looked like it
allowed
> > was custome tag names which we find very desirable. Any information on
this
> > would be welcome.
> >
> > Regards,
> > Bill Lucas
> >
> >
>
> Apart from all the (good) advise to get the latest patch, I doubt
> if this has anything to do with it.
> This script is designed to be called from an HTTP-enabled environment.
> Calls to OWA_UTIL (Oracle Web Application) and HTP (HyperText Package)
> will yield no effect on a sql prompt.
>
> Are you sure, this is meant to run like this?
> And there seems to be an error on line 10 of the script. Maybe it was
> written for a previous version of the OWA packages (they came with
> Designer/2000 before declared standard in the database).
>
> --
> Regards, Frank van Bortel
>
Frank,
Here is the link to the full page.
http://otn.oracle.com/tech/xml/htdocs/plsxml/install.htm
The pertaining excerpt says...
Make sure that your database schema has access to the following packages on
which PLSXML's utilities depend:
HTP
HTF
UTL_FILE
OWA
OWA_UTIL
UTL_HTTP
To easily determine if you have the appropriate access to these packages,
try running the checkdeps.sql script from the install subdirectory:
SQL> @checkdeps
I followed these instructions and got the errors listed in the OP. I ran the @checkdeps script from both my account and later from the sys account with the same results. I should also note that even trivial example scripts calling the htp package fail as well. I am currently installing a clean machine to see if I can trouble shoot this problem. If you have any further thoughts I would be interested in hearing them.
Thanks for the input.
Regards,
Bill
Received on Fri Feb 14 2003 - 07:12:51 CST