Database (Web Services Call-Out) class error

Posted by Steve Racanovic | Posted in , | Posted on 11:28 AM

2

When receiving the following error:

ERROR at line 1:
ORA-29540: class oracle/jpub/runtime/dbws/DbwsProxy does not exist

ORA-06512: at "SYS.UTL_DBWS", line 195

ORA-06512: at "INTERFACE.GET_JOKE", line 13

The java classes are not installed in the database user schema.

Logout of sqlplus and run:
loadjava -u / -r -v -f -s -grant public -genmissing  dbwsclientws.jar dbwsclientdb102.jar

Where user/password are the details of the database user using the database web service callout.

Further details can be found here:
http://www.oracle.com/technology/sample_code/tech/java/jsp/callout_users_guide.htm
http://www.oracle.com/technology/tech/java/oc4j/1003/how_to/how-to-ws-db-javacallout.html

Comments (2)

Do you want to say ???
loadjava -u user/password -r -v -f -s -grant public -genmissing dbwsclientws.jar dbwsclientdb102.jar

Yeah that right. Thanks