This forum is currently locked. You can't register or post questions at this time. (read more)

Errors while invoking webservices using UTL_DBWS

All posts relating to Oracle PL/SQL development.

Moderator: Tim...

Aryan
Member
Posts: 2
Joined: Fri Feb 17, 2012 11:17 am

Errors while invoking webservices using UTL_DBWS

Postby Aryan » Fri Feb 17, 2012 11:30 am

Hi,
I am trying to invoke a webservice using UTL_DBWS on 11g.
There were no errors while installation and the UTL_DBWS package was created without errors.

I get following errors while executing my script:
Error report:
ORA-29532: Java call terminated by uncaught Java exception: java.lang.IllegalAccessException: java.lang.NoClassDefFoundError
ORA-06512: at line 25
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.

Request to kindly let me know the issue with the above...

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Errors while invoking webservices using UTL_DBWS

Postby Tim... » Fri Feb 17, 2012 1:12 pm

Hi.

Not sure what the problem is because I can't replicate it myself.

A quick Google suggests that it may be something to do with the locale of the JVM. Check out the last response on this forum thread for a possible workaround:

https://kr.forums.oracle.com/forums/thr ... ID=2162997

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

Aryan
Member
Posts: 2
Joined: Fri Feb 17, 2012 11:17 am

Re: Errors while invoking webservices using UTL_DBWS

Postby Aryan » Fri Feb 17, 2012 2:17 pm

Hi Tim,
No Luck. I guess I am passing a wrong portname/servicename.
Is there a way to find a servicename and portname for a webservice, since we are using a third party service we do not have much details of it.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Errors while invoking webservices using UTL_DBWS

Postby Tim... » Fri Feb 17, 2012 2:48 pm

Hi.

This information should all me visible in the WSDL of the web service. It is XML, so it human readable.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle SQL and PL/SQL Development”

Who is online

Users browsing this forum: No registered users and 5 guests

cron