Posted by Steve Racanovic | Posted in DBMS Callout , Web Services | Posted on 11:28 AM
When receiving the following error:
ERROR at line 1:The java classes are not installed in the database user schema.
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
Logout of sqlplus and run:
loadjava -u http://www.oracle.com/technology/sample_code/tech/java/jsp/callout_users_guide.htm
Where user/password are the details of the database user using the database web service callout.
Further details can be found here: