Database Web Service Callout Utility Sample JPublisher 10.1.3.1 Fails With Error "ORA-904: Invalid Identifier". (Doc ID 560787.1)

Last updated on FEBRUARY 13, 2024

Applies to:

Symptoms

When attempting to run the sample code from following note

<Note 469588.1> - DBWS Callout Utilities User's Guide for RDBMS 11.1 (Doc ID 469588.1)

against a 64-bit 10.2.0.3 RDBMS following errors are reported when running the JPublisher command, you get output similar to the following:

/tmp/jpub/myProxyJPub.java
/tmp/jpub/plsql_wrapper.sql
/tmp/jpub/plsql_dropper.sql
/tmp/jpub/plsql_grant.sql
/tmp/jpub/plsql_revoke.sql
/tmp/jpub/myProxyJPub.java:33: package oracle.xdb does not exist
public static oracle.xdb.XMLType Numbers(oracle.xdb.XMLType __tgPt_0)
^
/tmp/jpubtemp/NumberConversionProxyJPub.java:33: package oracle.xdb does not exist
public static oracle.xdb.XMLType Numbers(oracle.xdb.XMLType __tgPt_0)
^
/tmp/jpubtemp/NumberConversionProxyJPub.java:169: package oracle.jdbc does not exist
if (_defConnVar==null) _defConnVar=new oracle.jdbc.OracleDriver().defaultConnection();
^ 
3  errors
Executing /tmp/jpubtemp/plsql_dropper.sql
Executing /tmp/jpubtemp/plsql_wrapper.sql
Executing /tmp/jpubtemp/plsql_grant.sql
Loading /tmp/jpubtemp/plsql_proxy.jar
Error while processing /tmp/jpubtemp/plsql_proxy.jar
Exception java.io.FileNotFoundException: /tmp/jpubtemp/plsql_proxy.jar (No such file or directory)
Error while opening file: /tmp/jpubtemp/plsql_proxy.jar
Exception java.io.FileNotFoundException: /tmp/jpubtemp/plsql_proxy.jar (No such file or directory)
The following operations failed
/tmp/jpubtemp/plsql_proxy.jar: opening file
exiting : Failures occurred during processing

When arriving at the following point in the note:
Section 3. Generating and Testing a Static Web Service Client Proxy

this step consistently fails with the following error:

SQL> select jpub_plsql_wrapper.sayhello('hello') from dual;
select jpub_plsql_wrapper.sayhello('hello') from dual
*
ERROR at line 1:
ORA-00904: "JPUB_PLSQL_WRAPPER"."SAYHELLO": invalid identifier

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.