A reader, December 18, 2005 - 6:44 pm UTC
Hi Tom,
It would be great if you give us working example of web service using UTL_DBWS package.
Thanks
A working example would come in really handy
kennie nybo pontoppidan, January 24, 2006 - 9:26 am UTC
The documentation of the package from the Types and Packages Reference is VERY minimal.
We tried to connect to a webservice called DeepThought, which offers a method called MeaningOfLife. The method takes no parameters and returns '42'.
The following script tries to connect, but fails at runtime, because input_params cannot be null. If I try to add a test-inputparameter I get a runtime error because the call does not validate aginst the XML-schemadefinition for the method.
So: some example code would come in handy.
Regards,
Kennie
declare
service sys.utl_dbws.SERVICE;
call sys.utl_dbws.CALL;
result ANYDATA;
wsdl_url varchar2(1024);
service_name varchar2(200);
operation_name varchar2(200);
input_params sys.utl_dbws.ANYDATA_LIST;
begin
wsdl_url := '</code>
http://172.30.32.173/DeepThought/DeepThought.asmx?WSDL'; <code>
service_name := 'DeepThought';
operation_name := 'MeaningOfLife';
service := sys.utl_dbws.create_service(
urifactory.getURI( wsdl_url ),
service_name
);
call := sys.utl_dbws.create_call(
service,
null,
operation_name
);
result := sys.utl_dbws.invoke(
call,
input_params
);
sys.dbms_output.put_line( 'Expected 42' );
sys.dbms_output.put_line( 'Got: ' || sys.anydata.AccessNumber( result ) );
end;
/
show errors
Web Services - using Soap/xml
ian gallacher, May 22, 2006 - 5:57 am UTC
Hi Tom,
I am looking at using Web services to access a non-oracle web service to gain access to their database. I would normally use HS ODBC to retrieve external data but an ODBC interface is not being set up
The route I have to go down is using a SOAP interface to generate xml to log into their database and to issue requests for information
Link to documentation is
</code>
http://www.show.scot.nhs.uk/sci/products/store/SCIStore_Documentation.htm <code>
then developer then store web services
Are their tools within the Application server 9i setup to use a SOAP interface to generate xml rather than going down the Microsoft Visual Basic and Microsoft SOAP route ?
Any comments would be useful
Thanks
Ian
May 22, 2006 - 7:59 am UTC
9i AS is rather "old", very very old. In the current releases - yes, lots of support for current technologies.
Web services in PL/SQL
A reader, July 18, 2006 - 11:55 am UTC
Tom,
Can web services be developed usig Oracle PL/SQL?
Can you please point me to some docuementation about web services in PL/SQL?
Thank you
July 19, 2006 - 8:22 am UTC
PLSQL webservices without Oracle AS
Tom, September 17, 2006 - 10:47 am UTC
Hi Tom,
I seem to remember that there was some suggestion that Oracle 10g would be able to publish plsql webservices straight from the database without needing an application server. Has this plan disappeared, been put back into 11g or have I just got a faulty memory?
September 17, 2006 - 1:01 pm UTC
currently UTL_DBWS lets us "consume" web services
but we still need the app server to publish them
RE: PLSQL webservices without Oracle AS
Chris Poole, September 17, 2006 - 8:08 pm UTC
Hi Tom,
But what about DBMS_EPG? Does that not allow you to publish a URL using mod_plsql without the external Apache server or another AS? It's in 10gR2... If it doesn't do that, what does it do?
Ta,
Chris
September 18, 2006 - 1:05 am UTC
you can use the embedded plsql gateway to run mod_plsql in the database - yes.
but that does not make it a "web service" yet. There is the soap envelope - parsing of inputs and so on that must be considered.
that gives us the transport, but not the entire implementation.
Please help me out
Arindam Mukherjee, November 08, 2006 - 1:19 am UTC
Respected Mr. Tom,
Your valuable suggestion is solicited here. Our client (Fortune 500 company) has Oracle 9i licensed copy. They want to build an application of Document Movement and Tracking System having the following features.
1. Web based user-friendly forms for data entry with individual password protected login screens
2. Various levels of security based on login access rights
3. The ONLINE system will monitor the comprehensive movement of any document throughout its entire life tracking from creation to closure / archiving stage.
My solution
Database Oracle 9i as it already exists to client and client sticks to this version. There is no more choice left.
Various security level - Fine Grained Access Control or DBMS_RLS I am not pretty sure how much help I can get in Oracle 9i version.
For Web based Forms Oracle 9i AS
For Document movement and tracking Oracle Workflow.
Looking forward sincerely to seeing your valuable advice on this solution if I have not considered yet. Performance and scalling of the application is the last or wining word.
Regards,
November 08, 2006 - 8:28 am UTC
FGAC is DBMS_RLS is VPD - they are all the same thing. There is no "or" about it. It was implemented in version 8.1.5, it exists in 9ir2, of course 10gr1 and 10gr2 added more features, but it was there and documented in 9ir2.
Why forms - why not an HTML based solution.
Oracle workflow (the plsql version) is going "out of support" soon, best probably not to start new development with it.
Please help me in Details
Arindam Mukherjee, November 08, 2006 - 10:50 am UTC
Respected Mr. Tom,
I am grateful to you for your caring response. I am afraid I could not understand the alternate of my solution. Its my humble request to you please to answer me the following points clearly.
You have written
1> Why forms - why not an HTML based solution.
You please suggest me the name of Oracle product supported by Oracle 9i R2 and I will explore that through Oracle document.
2> Oracle workflow (the plsql version) is going "out of support" soon, best probably not to start new development with it.
I have a plan to implement Oracle Workflow 2.6.2 supported by Oracle 9i R2. When the support is to be withdrawn, please suggest me another oracle product through which I can monitor document movement and tracking among various sections in an organization.
Anxiously waiting for your valuable advice.
November 08, 2006 - 7:56 pm UTC
1) jsp (java server pages) for example, there are hundreds, if not thousands of ways to do this in HTML.
</code>
http://apex.oracle.com/ <code>even - supports 9ir2
2) BPEL (business process execution language) part of application server.
BPEL Vs. Oracle Workflow
Arindam Mukherjee, December 27, 2006 - 2:00 am UTC
Respected Mr. Tom,
To your last two follow ups, you advised me not to use Oracle Workflow for fresh development rather we should use BPEL. Today I found one site www.oracle.com/technology/products/integration/pdf/Oracle_Integration_FAQ_public.pdf and there is one question and answer like below. Although this is old article updated December 2004.
Q. Will BPEL PM replaces OW4J?
No. BPEL Manager is not replacing Oracle Workflow/OW4J. Oracle Workflow/OW4J provides a comprehensive solution for application and human workflows for the Oracle E-Business Suite across ERP, CRM, HR and other modules.
As I am not aware of this new product Oracle BPEL - now my QUESTION - should we get all functionality of Oracle Workflow in BPEL PM.
December 28, 2006 - 8:35 am UTC
BPEL is an industry standard way of describing complex workflows - yes.
web service
sam, February 08, 2007 - 11:32 pm UTC
Tom:
1. I am not sure if the solution to this issue lies by using a web service but you can tell me the best way since you are the oracle expert.
I have an oracle 9i dbms server and it hosts a web application that used mod_plsql. Now this server sits behind a firewall.
We have a second machine for the oracle http server and that machine is outside the firewall and can connect to the database.
We are going to have a 3rd machine where vendors will upload digital files to the unix file system on a daily basis. The upload activity needs to be reflected in database flags on machine 1.
The idea is is have a perl script that runs nightly on machine 3 that scans the file system. We can then create a text file or xml file. Then I need somehow (behind the scenes) to update the columns in my database or insert new records based on the results found in this text file.
What do you think is the best way to do this?
i.e. upload file from machine 1 to machine 3 using oracle http server using some language and port 80 or how? Is there a pl/sql solution to this?
February 09, 2007 - 8:09 am UTC
why not just make the files accessible on the database server itself.
can machine 3 connect to oracle on machine 1?
web service
sam, February 10, 2007 - 12:31 pm UTC
Tom:
For security reasons, machine 1 and 3 will be separate. machine 1 will be contracted out to an external company and its primary purpose is for other vendors to download files to it over the internet.
Machine 3 can not connect to machine 1 (db server) which is inside the firewall. Unfortunately we can not change any of the existing network design.
Machine 3 (external) can connect to machine 2 which is where the 9IAS is installed via http.
I am trying to see if there is an oracle solution to this or you have to use something else. One of things that I read about is using SOAP message over HTTP to move an XML file from machine 3 to machine 1 (web service). Then you parse the file on machine 1 and fo the file updates based on content of the file.
I was looking at a book you recommend "Oracle Database Prgramming using Java and web services" but I did not get a chance to see if it applies here.
I apreciate your expertise/help in this matter.
February 12, 2007 - 10:17 am UTC
you can write software of your own design that runs in the app server
This software can use that protocol you specified (would make sense).
And this software you write, can take the information a program you write on machine 1 (the thing that reads the local input and posts it to the application server) and puts it into the database on machine 3.
web service
sam, February 12, 2007 - 10:44 am UTC
Tom:
Can you elaborate more. Not sure about details.
1. You are saying I need "piece of software" on external machine that puts the file on the app server.
Can this piece of sofware be written in oracle or it has to be something like perl or Java? what would you use?
2. You said I need another piece in the app server that copies file to database or call the client machine?
3. Is this sort of web service design and do you know of a reference that shows an example for doing this.
February 12, 2007 - 11:41 am UTC
1) you need to write a client application - I am not sure what you mean by "written in oracle", you can write programs that access Oracle, you don't really "write in Oracle" (well, stored procedures maybe, but you don't have a database on this machine)
2) yup, you need something to talk to in the middle tier.
3) beyond the scope of what I do here, this is just the "way the web works" - it is the way pretty every web based application works.
on client machine (where files are) you write client code (sometimes this client code is just a web browser - not in your case...)
it talks to a middle tier where more code you write resides
the middle tier does something to the input data and puts it into the database
web service
sam, February 14, 2007 - 7:18 pm UTC
Tom:
1. Can this "moving a file over http" can be implemented using a web service solution (SOAP/XML) and non-web service solution (client program making http calls). correct?
2. You can upload a form using HTML form and submitting the form to an oracle procedure that uses doc load. Is it possible to write a client program that does what the browser do which I guess sending the HTTP message to the oracle server via mod_plsql.
3. What is Oracle SOAP client API? Can this be installed on a unix server and programmed to send SOAP messages instead of using (java or perl)?
4. Does Oracle provide a SOAP server as part of the ORacle 9IAS to be used for web services and receive SOAP messages?
Thanks,
February 15, 2007 - 11:35 am UTC
1) sure
2) sure, since people can and have in fact written web browsers, you have 100% proof that you could. However there are many API's in languages already that help you automate this, so you can do this easily
3) there isn't really one, SOAP is a standard for defining what the data will look like, how it is encoded.
4) there are standard java apis for this stuff, you write a middle tier application to handle it.
web service
sam, February 15, 2007 - 3:08 pm UTC
om:
1. Do you know of any APIs that do that on a unix box? Would you be writing a java, perl, C program for this? i think you need a program that creates the HTTP header, attach the file name on the file system, open a socket and then send the message?Any examples.
2.Here is a link of Oracle SOAP client and server.
http://www.lc.leidenuniv.nl/awcourse/oracle/appdev.920/a96616/arxml11.htm http://download-east.oracle.com/docs/cd/B32110_01/web.1013/b28236/adx11soa.htm I am not sure though where you load these and how you use it to move a file from machine A to machine B. It seems these get installed on the 9IAS middle tier (not database) and serve as a SOAP server talking to SOAP clients?
3. It seems to me if you use SOAP then we need a SOAP server and Java code in the middle tier. The SOAP server will be receving requests from the Apache web server and forwarding the request to the JAVA code which talks to the database and then database send response back to program which in turns forwards to SOAP server and back to client.IS this correct?
Thanks,
February 16, 2007 - 1:32 pm UTC
1) i'd be looking for almost any other way - all we need to do is get files to database machine and then we'd be set to go, plsql would be all I'd need.
each of those languages have dozens of publically available API's - I'm not the right one to pick one for you.
2) that is a pointer to Oracle docs that states "you need a client". the XDK is in the database, if you got the files to the database - we'd be set and wouldn't even need this extra layer of complexity.
3) soap is just a protocol. you would need a client on machine 1, something on the application server willing to listen to machine 1 and receive inputs from it. that something on the app server would have to know what to do with these inputs and do the right thing in machine 3, the database.
web service
sam, February 16, 2007 - 4:29 pm UTC
Tom:
1. Is this a correct statement.If not, can you elaborate on how it is done.
If you have the 9IAS machine outside the firewall and the database server inside the firewall, there has to be a hole in the firewall that allows the database to talk to the MOD_PLSQL. I think the communication here is using NET*8 (not HTTP) through the database listener port?
2. I think what those documents imply, is that the oracle database has a SOAP engine in it that can accept SOAP requests from a client. Is this correct?
If that is correct how does the communication work, meaning does the SOAP client send a request to oracle apache http server, which forwards SOAP request to MOD_PLSQL and then to SOAP server inside the database.
I think there must be a java servlet on the (9IAS) for forwarding SOAP requests and mod_plsql does not get involved?
3) Comenting on your answer for (3) above:
<you would need a client on machine 1>
OK, this is the SOAP client prgoram that send XML based message
<something on the application server willing to listen to machine 1 and receive inputs from it>
Well we have apache web server listening on port 80 or 7776. That is part of the 9IAS?
<that something on the app server would have to know what to do with these inputs and do the right thing in machine 3, the database>
This means that the program has to be in JAVA if it is in the middle tier. Can you use any other language inside the ORacle 9IAS (unles you use cartridges)
February 18, 2007 - 8:55 am UTC
1) you have to permit sqlnet traffic, yes. this need not be a "hole", you do need to let sqlnet traffic through (and many firewalls can 'check' to verify that it is sqlnet traffic not something else)
2) soap is just a protocol (he keeps saying) for encapsulating a message. You can use that protocol to talk to your middle tier. You can use it to talk to the database if you like. Mod_plsql is very far and away removed from "soap", you talk to mod_plsql using http GET and POST requests, mod_plsql talks to the database using sqlnet.
web service
sam, February 17, 2007 - 1:29 pm UTC
February 18, 2007 - 9:46 am UTC
you use GET and POST - the http protocol - to talk to mod_plsql. http specifies how files would be "uploaded", how they would be encoded to be uploaded.
web service
Sam, February 18, 2007 - 3:03 pm UTC
Tom:
I think the easiest way to implement this using the current environemnt is as follows (no need for web service or anything in middle tier). Do you agree?
1. Create an HTML form for uploading a file from the local server (i.e <input type=file name="/upload/test.txt" .
2. Create a script (perl, python, java, C, etc) that can url encodes the file , and posts the HTML form to the database (using mod_plsql). This will do same thing a browser do.
An alternative here is to write a program that creates an HTTP message and create a TCP/IP connectio and send the http message but that would require more work.
3. Create a pl/sql stored procedure that uploads the incoming file to the database ( i do not think we can save it to file system).
The procedure will then parse this file and loads the data inside to another table or do database updates based on the parse/table.
thanks,
February 18, 2007 - 8:11 pm UTC
why do you need #1 if you are doing #2, you only need #1 if you - well - use a browser.
#3 is something mod_plsql does - it'll put the file into the database and then call a stored procedure - passing it the lob locator of the uploaded document.
web service
sam, February 18, 2007 - 9:27 pm UTC
Tom:
1. There are http client programs (cURL, wget) that can be used to post an html form to a web server. The script will simply call these tools which refer to an html file. I guess what you are saying is to embed the html input fields in the script itself (where you call these tools) instead of calling an html file. Is that correct?
2. If my upload procedure uses wpg_docload and saves the text or xml file as a blob in the database. How would I be able to parse the data (i.e. load it ta table and do my updates based on that)?
let us say the file had this info:
empid,name,salary
"100","John Wesley","10000"
Let us say that based on this record I need to update the salary column in my EMP table for empid=100.
Also, if this empid is not there, I want to add it to the EMP table.
February 19, 2007 - 9:23 am UTC
1) there are thousands of tools for doing this, I would suggest, umm - WRITING CODE where by you stand a ghost of a chance of detecting errors, handling errors and recovering gracefully.
2) you would read the XML developers guide to explore all of you options.
http://www.oracle.com/pls/db102/portal.portal_db?selected=3#index-XML
Jos Dols, February 19, 2007 - 1:00 am UTC
Hi Tom,
Is it possible to use UTL_DBWS in the XE version? It seems that this package is not installed by default.
Jos
February 19, 2007 - 9:27 am UTC
no, the java stuff is not there.
web service
sam, February 19, 2007 - 10:41 am UTC
Tom:
It would take some time to read this XML developer guide, but in brief if we bring the a comma delimited file or xml file into an oracle table or a unix file system, can pl/sql break the data in this file and load it into a table?
thanks,
February 19, 2007 - 10:45 am UTC
you can write whatever code you want to write, of course you can break a delimited file up using code.
And yes, once you do your due diligence (eg: your job really - what you are supposed to do) and read up on the options in the XML guide, you'll see the myriad set of options open to you with XML.
You are writing something that will be used for a while, slow down - do it right. Someone is going to have to maintain this.
web service
sam, February 21, 2007 - 2:21 pm UTC
TOm:
IF you have
9i dbms server = machine 3
9IAS (mod_plsql) = machine 2
Client unix machine machine 1
I want to create a pl/sql procedure in machine 3 that works as a web service to process the file sent from machine 1.
What do I exactly need to do.
Can I send the SOAP/XML message (xml file) from machine 1 through mod_plsql to my database. or do I need a SOAP server somwhere in the middle tier or database.
Can you explain how comunication is exactly done when oracle server as a web service provider.
thank you,
February 21, 2007 - 3:30 pm UTC
you need to write some software in the middle tier.
Jdeveloper can publish that for you - generate the software.
you do "soap" (just a protocol over tcp) from machine 1 to machine 2. Machine 2 will not invoke mod_plsql (since that doesn't speak soap), rather it'll run your software (could be generated by jdev) which in turn will run your stored procedure.
http://www.oracle.com/technology/tech/webservices/htdocs/series/plsql/index.html
web service
sam, February 22, 2007 - 8:40 am UTC
Tom:
From reading this, it sounds that Jdeveloper will publish the package as a web service.
1. However, do not you need OC4J (oracle Container for J2EE) installed in the 9IAS?
2. Would the SOAP request be processed as follows:
SOAP client -->oracle http server
oracle http server -->SOAP server (9IAS OC4J/servlet)
SOAP server ---> PL/sql package in Database server using JDBC
and response back the same way to SOAP parser on the client.
3. Do you agree that using http client programs might be easier than setting up web services and using those to trasfer and process files over http?
February 22, 2007 - 8:59 am UTC
yes, you sort of need the INFRASTRUCTURE - the stuff I've been talking about - *the code* in the middle tier to do stuff.
the communication would simply be:
client uses tcp ip to talk to application server
application server gets request and processes it by connecting to database and doing something
3) no, not really. you are not sitting there with a web browser doing uploads - you sort of have no real error handling capabilities.
I starting (no, I've already started) to REPEAT MYSELF.
Do this right
Do this "robust"
This code will be around for a while
Do not hack together scripts without any error handling capabilities
Face the fact that you will have some code here, you will write some code here, you will probably write a bit of code here.
web service
sam, February 22, 2007 - 10:55 pm UTC
Tom:
I thought you were against the theory of "reinventing the wheel" and writing new code and favoring the use of existing already written code. This is what those http clients are.
If I decided to use the web service approach, and I have 9IAS already installed, do I need any special install/configuration for the OC4j stuff. Or everything gets is installed by default and the 9IAS is ready to support web service? web service can be inside or outside database.
February 23, 2007 - 7:32 am UTC
I am - however, you sort of want something "robust" here - something you can do error handling, retries upon failure, logging, alerting you of problems.
the code in the database - you write
the code in the middle tier - as told to you - can be generated by jdeveloper
the code on the client, suggest you use an API (the wheel) and write a robust program to do the processing of the inbound files.
please utilize support for installation and configuration
web service
sam, March 02, 2007 - 11:26 pm UTC
Tom:
Would this be a valid alternative to using http clients or web service.
1. Can not you create a pl/sql procedure in the database that uses UTL_TCP and schedule it nightly to download the files from the remote server (instead of remote server uploading it)?
2. Is UTL_TCP only for HTML files? or you can download XML and text files with it too.
3. Does UTL_TCP require web server installation on remote server (port 80)?
March 04, 2007 - 1:00 pm UTC
1) if you have something on the remote machine that lets you connect to it and serves files. so - do you.
2) utl_tcp and html?!?!?!?!? I do not see how you got these two things tied together at all.
3) only if you want to talk to a web server.
Connecting to 10g from JDev.
Girish, April 12, 2007 - 5:33 am UTC
Hi Tom,
I have installed Jdev studio and Oracle 10g apex. How can I create a connection from Jdev to 10g for creating an entity object? Please do suggest.
Thanks,
Girish
utl_dbws with complex types
Chris, June 12, 2007 - 9:19 am UTC
Hi Tom,
I have just started experimenting with UTL_DBWS. I would like to call a web service that requires a complex type as its input as follows:
<MyRequest><request name="a name" /></MyRequest>
I have tried with both versions of invoke.
If I use an XMLTYPE then the attribute is lost in the call to the server, as follows:
<MyRequest><request /></MyRequest>
If I try with an ANYTYPE as a string then the request element is encoded as follows:
<MyRequest><request name="a name" /></MyRequest>
Any help you could give me would be greatly appreciated.
Regards
Chris
Is utl_dbws available in 9iR2?
Reed, March 05, 2009 - 10:40 am UTC
Although I would like to upgrade I am stuck on Oracle 9i due to some application constraints we are working through. I noticed this thread and thought it would help with what I am trying to implement but it is a little sparse.
I have a batch process that I need to add a step that gets some information from a web service. I have not found much that shows where/how SQL or a PL/SQL procedure can consume a web service. Is UTL_DBWS available in 9iR2? If so is there somewhere I can find sample code that implements it? if not, what, if anything, is available that will allow me to consume a web service from SQL in 9i? Any examples of this approach would help also.
Thanks
March 05, 2009 - 2:04 pm UTC
Thanks Very Much
Reed, March 06, 2009 - 1:03 pm UTC
This should be fun!
Unable to connect to Warehouse Builder Browser
Mallik, March 19, 2009 - 9:00 am UTC
Hi Tom,
I have installed Oracle DB 10gR1 and OWB 10gR1 on in Windows 2003 Server and configured all the settings as per Install and configure guide. Installed Oracle HTTP Server from companion CD.
I have updated "dads.conf" file as said in the documentation. Compiled dadsTool.pl successfully.
Now HTTP Server is running and started service OC4J instance. I observed in command prompt of OC4J instance shows; Invalid jsp talib location. But, Oracle Application Server Containers initiated.
When I try to connect from clients for Warehouse Builder Browser. I tried from programs -> OWB Home -> Warehouse Builder -> OWB Design Browser, it opened internet explorer with -
http://127.0.0.1:8999/owbb/DBLogin.uix I have provided all details for HTTP Server Host, HTTP Server Port, HTTP Server DAD;
Finally its showing The page cannot be found and the address contains;
http://127.0.0.1:8999/owbb/DBLogin.uix?host=pts32&port=7777&service=pisl_owb_rep&event=viewDesign When I looked at OC4J instance command prompt; its showing
http://pts32:7777/pls/pisl_owb_rep/pisl_owb_rep.wmp_api_call.home Please guide me the steps to fix HTTP Server issue and run the OWB Design Browser and Audit Browser.
Thanks
Mallik
Advanced Queues as Web Services
Vladimir, October 16, 2009 - 1:38 pm UTC
Hello Tom.
I need to publish an advanced queue as a web service.
I've read the very useful articles you mentioned in this post.
One of them (
http://www.oracle.com/technology/pub/articles/mensah_dws.html ) says that "For example, many customers reuse existing database assets—such as PL/SQL stored procedures/functions and packages, Java stored procedures/functions, pre-defined SQL queries, DML, and Oracle Advanced Queuing processes—as standards-based Web services."
It looks like I am running in circles through Oracle documentation. I am not able to find info on how to publish an advanced queue as a web service. Could you point me to the manual that explains how to do that, please?
As a workaround I an thinking of creating a PL/SQL package to dequeue messages off the queue and then publishing it as web service. Is it a reasonable approach? Will I have to use OAS in this case anyway?
Oracle 10G Rel 2 database is used.
Thank you in advance
Vladimir
Database Call Ins
Ravi Chengalvala, November 10, 2010 - 10:38 am UTC
Tom,
Can we expose Database Call In's witout using Oracle Application Server? Are database Call-Inwebservices from Oracle 10G R2 be hosted on Weblogic 9.2? Please advise.
Reagards,
Ravi Chengalvala
venkat, July 27, 2011 - 7:41 am UTC
Tom,
Please let me know how can I consume a webservice ( III party URL with 2 params) from with in a PL/SQL stored procedure in Oracle 9.2.0 ? do i need to use UTL_DBWS / uTL_HTTP package . can u send me brief step by step procdure to setup/ invoke a webserivce ?
thanks
venkat.