[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

utl_http efficiency over utl_dbws

Posted on 2011-02-11
3
Medium Priority
?
2,327 Views
Last Modified: 2012-05-11
One last question regarding utl_dbws:

I just tested the callout sto a webservice over https, comparing utl_http calls with utl_dbws calls. I found that processing times were more than twice as fast with utl_http over utl_dbws.  

Has anyone else experienced this? This could be a deciding factor in what to make the standard for development in our team for callouts.  Are there certain things to consider regarding the environment that may be causing utl_dbws to be so much slower?
0
Comment
Question by:Melodi Roberts
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 1000 total points
ID: 34873391
utl_dbws parses your inputs and constructs a response to send to the service.
Even in when you send a pre-constructred XMLTYPE input, that input is then parsed and reconstructed into a new xml string that is sent.  There are other validations on the inputs too.

All of that work is overhead that you don't incur with utl_http.

use
utl_dbws.set_logger_level('ALL')  and dbms_java.set_output
  to turn on debugging for your utl_dbws code and you can see logs of some of the work it does
the output will be written to the dbms_output buffer
0
 

Author Comment

by:Melodi Roberts
ID: 34896965
Thanks so much for the info.  We're probably going to develop a generic package for soap communications using utl_http instead of using utl-dbws.  When processing over 10K records, that extra overhead really adds up.
0
 

Author Comment

by:Melodi Roberts
ID: 34901175
Just an additional note:  Found a generic soap package using utl_http already written and available at this site: http://www.oracle-base.com/articles/9i/ConsumingWebServices9i.ph
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question