[prev in list] [next in list] [prev in thread] [next in thread] 

List:       odtug-sqlplus-l
Subject:    RE: PL/SQL SOAP call-outs
From:       "John Hopkins" <HHOPKINS () mail ! mcg ! edu>
Date:       2008-02-27 19:55:28
Message-ID: F001.006133BB.20080227115528 () fatcity ! com
[Download RAW message or body]

I implemented the code (with some very minor tweaks) from the site Jeff mentioned.  \
Worked like a charm.

Thanks for that, and for confirming that UTL_DBWS isn't quite soup yet.
-John

> > > "John Flack" <JohnF@smdi.com> 2/27/2008 11:40 AM >>>
It is also supposed to be possible to write a web service client in
Java, and put the Java into the database as a Java Stored Procedure.
But all the libraries that your procedure calls have to be in the
database too.  The SOAP libraries AREN'T among the ones that Oracle
loads by default when you install the JVM - at least they aren't in 9i
or 10gR1.  There are instructions for loading them, but I never got it
to work.  My PL/SQL clients to REST web services use UTL_HTTP and work
great.

 

________________________________

Sten Vesterli
Sent: Wednesday, February 27, 2008 10:41 AM
To: Multiple recipients of list ODTUG-SQLPLUS-L

 

I concur with Jeff - use an UTL_HTTP solution if possible. 

 

I tried to follow the instructions for using UTL_DBWS - it loads
thousands of classes into the database and spews errors right and left,
so I gave up on it.

 

Best regards

 

Sten Vesterli

www.vesterli.com 

	 

	
________________________________


	From: ml-errors@fatcity.com [mailto:ml-errors@fatcity.com] On
Behalf Of Jeff.Naumann@Rotometrics.com 
	Sent: 26. februar 2008 20:55
	To: Multiple recipients of list ODTUG-SQLPLUS-L
	Subject: Re: PL/SQL SOAP call-outs

	
	I didn't use UTL_DBWS, but I did find this demo which uses
UTL_HTTP. 
	
http://www.oracle-base.com/articles/9i/ConsumingWebServices9i.php 
	
	  It gave me enough of a guide that I was able to modify it so
that I could consume an internal web service using PL/SQL code. 
	
	Now if I could find a way to provide a web service using only
PL/SQL code . . . 
	
	HTH 
	jeff 
	
	
	
	
--------------------------------------------------------------------- 
	This e-mail message is intended only for the personal use of the
recipient(s) named above. This message is confidential. If you are not
an intended recipient, you may not review, copy or distribute this
message. If you have received this communication in error, please notify
the sender immediately by e-mail and delete the original message. 
	
--------------------------------------------------------------------- 
	
	. 
	
	
	

"John Hopkins" <HHOPKINS@mail.mcg.edu> 
Sent by: ml-errors@fatcity.com 

02/26/2008 12:00 PM 

Please respond to
ODTUG-SQLPLUS-L@fatcity.com 

To

Multiple recipients of list ODTUG-SQLPLUS-L
<ODTUG-SQLPLUS-L@fatcity.com> 

cc

 

Subject

PL/SQL SOAP call-outs

 

 

 

	
	
	
	All,
	
	I'm faced with having to call a SOAP function after table row
insert/updates.  I can't introduce new tiers at this point, so I was
hoping to do this out of PL/SQL.   
	
	Has anyone used UTL_DBWS successfully _out of the box_?  My most
recent encounter (10.2.0.1.0) has Oracle throwing errors.  Metalink note
412666.1 says it applies to this version, but the jar files you need to
load are for 10.2.0.2.0 or higher. 
	
	Before sending our DBA staff on a wild goose chase, I'm
wondering:
	
	Is anyone using the above package in 10.2.0.1.0 successfully?
	
	Alternatively, does anyone know of a PL/SQL wrapper for SOAP
that is less touchy and doesn't require me to create my own SOAP body
XML?
	
	Input greatly appreciated.
	
	Thanks,
	-John
	
	
	
	H. John C. Hopkins
	Systems Analyst
	Information Technology
	Medical College of Georgia
	1120 15th Street, HS2151
	Augusta, GA  30912
	
	voice: 706-721-4925
	fax: 706-721-6292
	
	
	
	-- 
	For more information on this topic or to become a member, visit
our web site at http://www.ODTUG.com  Be sure to check out our Seriously
Practical (SP) Conferences coming up this year! 
	
	ODTUG is pleased to announce that Kaleidoscope 2008 will be held
at The New Orleans Sheraton from June 15-19. Keep checking www.ODTUG.com 
for more details.
	
	-- 
	Author: John Hopkins
	 INET: HHOPKINS@mail.mcg.edu 
	
	Fat City Hosting, San Diego, California --
http://www.fatcity.com 
	
---------------------------------------------------------------------
	To REMOVE yourself from this mailing list, send an E-Mail
message
	to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and
in
	the message BODY, include a line containing: UNSUB
ODTUG-SQLPLUS-L
	(or the name of mailing list you want to be removed from).  You
may
	also send the HELP command for other information (like
subscribing).
	
	



-- 
For more information on this topic or to become a member, visit our web site at \
http://www.ODTUG.com  Be sure to check out our Seriously Practical (SP) Conferences \
coming up this year! 

ODTUG is pleased to announce that Kaleidoscope 2008 will be held at The New Orleans \
Sheraton from June 15-19. Keep checking www.ODTUG.com for more details.

-- 
Author: John Hopkins
  INET: HHOPKINS@mail.mcg.edu

Fat City Hosting, San Diego, California -- http://www.fatcity.com
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ODTUG-SQLPLUS-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


[prev in list] [next in list] [prev in thread] [next in thread]