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 MARCH 22, 2017

Applies to:

Web Services - Version 10.1.3.0.0 to 10.1.3.4.0
Information in this document applies to any platform.
***Checked for relevance on 26-Jun-2013***


Symptoms

When attempting to run the sample code from following note
<Note 428775.1> - DBWS Callout Utilities User's Guide for RDBMS 10.1 or 10.2

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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms