Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: stored procedure

Re: stored procedure

From: Finn Ellebaek Nielsen <_remove_fen_remove__at_changegroup.dk>
Date: Wed, 20 Nov 2002 18:31:07 +0100
Message-ID: <3ddbc6db$0$18473$edfadb0f@dread12.news.tele.dk>


If you mean "is is possible to expose a stored procedure as a Web Service": It is indeed, you wrap them up in Java code by clicking around in JDeveloper. Check out
http://otn.oracle.com/tech/webservices/htdocs/series/plsql/content.html.

If you mean "is it possible to invoke a Web Service from a stored procedure": If you can invoke the Web Service through HTTP you should be able to use UTL_HTTP.

HTH. Finn

--
---------------------------------------------------------------------------
 Finn Ellebaek Nielsen                           ChangeGroup ApS
 Product Manager, Principal Consultant, Partner  Kronprinsessegade 54, 4.
 E-mail: finn.ellebaek.nielsen_at_changegroup.dk    DK-1306  Koebenhavn K
 Mobile: +45 20 32 49 25                         Denmark
 Phone:  +45 33 32 77 78                         http://www.changegroup.dk
---------------------------------------------------------------------------
                      "Where do you want to GPF today?"
"buggs" <buggs_at_nomade.fr> wrote in message
news:argesm$hac$1_at_s1.read.news.oleane.net...

> hi,
>
> Who can tell me if it's possible to call web services in stored
procedures.
>
> thanks for your answers.
>
>
Received on Wed Nov 20 2002 - 11:31:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US