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:3E4D681F.4050005_at_netscape.net...
> Bill Lucas wrote:
> > "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
> >
> >
>
>
>
>
>
>
>
>
>
>
>
>
>
Frank,
I tried the corrected checkdeps.sql script you supplied (Thanks again), this time however I got this message...
SQL> @Checkdeps2.sql
Input truncated to 1 characters
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.OWA_UTIL", line 355 ORA-06512: at line 11
Any thought on what may have caused this? I tried this on a brand new server that I just installed. I should tell you I haven't put the latest patch on yet. I am going to do that now to see if it helps, but I thought I would post this to see if there is something else missing.
Thanks,
Bill
Received on Tue Feb 18 2003 - 08:52:51 CST