| utl_dbws how to [message #437159] |
Thu, 31 December 2009 06:34  |
Ezio
Messages: 2
Registered: December 2009
Location: Grosseto
|
Junior Member |
|
|
Dear all,
I need to build a webservice client from inside Oracle db.
Since I had a client prototype made by our provider, I verified it from inside Eclipse with real data: it worked.
Then I tried to import the needed jar files (official AXIS and 2 libraries by the provider) into Oracle in order to generate the same code in the database. Yet a lot of libraries were not validated by the db and surely they were necessary, since I obtained a runtime exception from Java.
At last I tried utl_dbws,after patching oracle jar's, giving right privileges to a user. I followed some good code published in this forum under forum/t/99528/2/ .
Nevertheless when I try to invoke the final call that utl_dbws.invoke, after I have passed through the wsdl without errors and populated my variables, I have a runtime error again, something like a type mismatch between Oracle and Java.
My general question is :
If I publish the pure java client prototype, the wsdl, the partial and wrong .sql I'm trying to build, knowing the xml and the operations I have to execute, could you help me build the good .sql?
In order to bypass the problem I wrote a stupid client socket for oracle database and in another machine an application for a server socket containing the client webservice, but you all understand it is a very bad solution.
Thank you in advance.
Ezio.
|
|
|
|
| Re: utl_dbws how to [message #437167 is a reply to message #437159] |
Thu, 31 December 2009 09:10  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
You have code & do not understand the problem, so
why do you expect us to be able to debug code we can not see?
If you can't make Oracle & Java to play nice together, perhaps you should keep them apart so they don't get into disagreement over variable datatypes.
I have a basic design philosophy.
First make it work; then make it fancy.
If you can't make PL/SQL & Java exchange parameters at static code level, then fighting the additional complexity of Web Service is a waste of time & effort.
[Updated on: Thu, 31 December 2009 09:38] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
