Home » Other » General » Jpublisher giving error for publish table (Oracle 11g)
Jpublisher giving error for publish table [message #671030] Fri, 10 August 2018 06:23 Go to next message
vykalra
Messages: 5
Registered: November 2012
Junior Member
Hello,

As per the Jpublisher documentation, we can use the tables to expose them as web service
Link: https://docs.oracle.com/cd/B28359_01/java.111/b31225/chtwelve.htm#CBBEDIDD

"Improves PL/SQL Web services by extending the Web services support for additional PL/SQL types, including CLOB, BLOB, XMLTYPE, REF CURSOR, and PL/SQL records and tables"

However, when I try to use the following command it seems to fail. I am able to generate the classes for the package though!

C:\product\11.2.0\client_1\bin>jpub -user=<user>/<password> -url=jdbc:oracle:thin:@<IP>:<DBName> -sql=inv
oracle.jpub.JPubException: J2T-116, ERROR: Type or package ZSUSER.INV was not found in the database

If I use the following query directly on the database then it works fine, so it cannot be access related issue. Can you please guide ?

select * from inv


[Updated on: Fri, 10 August 2018 06:24]

Report message to a moderator

Re: Jpublisher giving error for publish table [message #671050 is a reply to message #671030] Mon, 13 August 2018 04:21 Go to previous message
vykalra
Messages: 5
Registered: November 2012
Junior Member
any idea on this ?
Previous Topic: 18c XE delayed - again
Next Topic: DB 12.2 New Features Guide
Goto Forum:
  


Current Time: Wed Aug 15 23:10:27 CDT 2018