Home » SQL & PL/SQL » SQL & PL/SQL » Consuming a Java Web Service from PL/SQL using UTL_DBWS (Oracle 10g)
Consuming a Java Web Service from PL/SQL using UTL_DBWS [message #409271] Sun, 21 June 2009 12:28 Go to next message
arubalcaba
Messages: 2
Registered: June 2009
Location: Texas
Junior Member

I've been doing research and on how to consume a Web Service from PL/SQL. The following is a chunk of the code. I can call the Web Service from other clients but not from my PL/SQL client. I keep getting this error

ORA-29532: Java call terminated by uncaught Java exception: service: RewardsValidationService does not contain port: RewardsValidationPort

What am I missing and can someone lead more to better info on using UTL_DBWS.

I am attaching a file labeled more info that has the original Error message and the WSDL being used. I can't post it here because I'm new and not allowed to post links with in my first couple of post.

Any help is greatly appreciated.

  • Attachment: MoreInfo.txt
    (Size: 16.28KB, Downloaded 1322 times)
Re: Consuming a Java Web Service from PL/SQL using UTL_DBWS [message #409276 is a reply to message #409271] Sun, 21 June 2009 17:01 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.lmgtfy.com/?q=oracle+UTL_DBWS

http://www.lmgtfy.com/?q=oracle+call+"web service"
Re: Consuming a Java Web Service from PL/SQL using UTL_DBWS [message #409277 is a reply to message #409276] Sun, 21 June 2009 17:10 Go to previous messageGo to next message
arubalcaba
Messages: 2
Registered: June 2009
Location: Texas
Junior Member

Hey Thanks! Black Swan. I actually tried most of those links way before I posted here and I was wondering what I missed.


I actually tried the first link.



and I was wondering if someone could look at my code and tell me what I missed. My error is related to the port name. Saying it doesn't contain the port but if you look at the WSDL its there.

Also other clients can call that service ok except for PL/SQL.
Re: Consuming a Java Web Service from PL/SQL using UTL_DBWS [message #409278 is a reply to message #409271] Sun, 21 June 2009 17:21 Go to previous message
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.

29532, 00000, "Java call terminated by uncaught Java exception: %s"
// *Cause: A Java exception or error was signaled and could not be
//          resolved by the Java code.
// *Action: Modify Java code, if this behavior is not intended.


Quote:

ORA-29532: Java call terminated by uncaught Java exception: service: {http://10.93.38.134:7001/nmrwws/RewardsValidationService}RewardsValidationService does not contain port: {http://10.93.38.134:7001/nmrwws/RewardsValidationService}RewardsValidationPort



If you run a Browser from DB server, what happens with following URL?

http://10.93.38.134:7001/nmrwws/RewardsValidationService}RewardsValidationService

Is a firewall getting in the way?

Realize Oracle is simply reporting that Java throws exception.
If you don't like what Java reports, take it up with Java.

http://www.lmgtfy.com/?q=java+"does not contain port"

http://forums.sun.com/thread.jspa?threadID=738439&tstart=4035

[Updated on: Sun, 21 June 2009 18:01]

Report message to a moderator

Previous Topic: updating table 2
Next Topic: how to validate the input for alphanumaric in oracle 9i
Goto Forum:
  


Current Time: Wed Feb 12 07:14:12 CST 2025