Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: URL check procedure
Greetings,
as I found so far, the job can not be done with Oracle8. Oracle8 seems to
only have 'request' and 'request_pieces' functions without any status
indicator. The additional functions for HTTP communication are for Ora9i
only :-(.
So I probably write it in Java.
But thank you anyway for your answers,
Pavel
> Pavel,
>
> Look at the example code posted on the link where you read about the
> package.
>
> These might give you some ideas on how to solve your problem.
>
> --
> Ron Reidy
> Oracle DBA
>
> Pavel Vetesnik wrote:
> > Thank you Ron,
> >
> > I've learned about the utl_http package at
> > http://rainbow.mimuw.edu.pl/oracle9i/appdev.901/a89852/utl_http.htm.
> > But the problem is, that I can use only very small subset of functions
(I
> > can use UTL_HTTP.REQUEST and UTL_HTTP.REQUEST_PIECES).
> >
> > Please what should I do to use the other ones? Like
UTL_HTTP.Get_Response()
> > for example, which seems to solve my problem.
> > We have Oracle 8 installed.
> >
> > TIA,
> > Pavel
> >
> > "Ron Reidy" <rereidy_at_indra.com> píse v diskusním príspevku
> > news:3E4F80A2.7030309_at_indra.com...
> >
> >>utl_htp
> >>
> >>--
> >>Ron Reidy
> >>Oracle DBA
> >>
> >>Pavel Vetesnik wrote:
> >>
> >>>Hello,
> >>>
> >>>we have database with URLs of various information sources on Internet.
> >>>I was asked to write a procedure, that will "visit" each of them and if
> >>
> > it
> >
> >>>does not exist (404 error) then it will perform some action.
> >>>
> >>>Do you think, that it is possible in PL/SQL? If so, can you point me to
> >>
> > some
> >
> >>>package, that will perform the http connection and get the result?
> >>>
> >>>Thank you in advance,
> >>>Pavel
> >>>
> >>>
> >>
> >
> >
> >
> >
> >
> >
>
Received on Tue Feb 18 2003 - 02:26:42 CST