Database Administration (MOSC)

MOSC Banner

ORA-29540: class oracle/jpub/runtime/dbws/DbwsProxy does not exist

edited Jun 18, 2018 2:08PM in Database Administration (MOSC) 6 comments

Hi,

I am getting above error when i tried to execute one package  which  use UTL_DBWS Package for calling/executing Web service.

Schema: <MYSCHEMA> is the schema where i have created my package and trying to execute web service using UTL_DBWS

Using SYS schema , i have following details below to analyse

SELECT owner, status, count(*) FROM DBA_OBJECTS
  WHERE OBJECT_TYPE='JAVA CLASS'
  GROUP BY owner, status;

Output

Owner                    Status          Count
<MYSCHEMA>                 INVALID       98
MDSYS                  VALID        254
SYS                       VALID         14828
<MYSCHEMA>              VALID            4056
EXFSYS             VALID             41
ORDSYS            VALID            1388

I am also querying below statment for check:

select object_name,status from all_objects where

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center