| Jpublisher giving error for publish table [message #671030] |
Fri, 10 August 2018 06:23  |
 |
vykalra
Messages: 10
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 #671261 is a reply to message #671257] |
Mon, 20 August 2018 07:12  |
|
vykalra
Messages: 10
Registered: November 2012
|
Junior Member |
|
|
Yes INV is a table, I checked the all_objects table and the OBJECT_NAME value is INV in this case. (with owner being ZSUER )
I tried to give -sql=INV and -sql=ZSUSER.INV , in both cases I get the following error.
oracle.jpub.JPubException: J2T-116, ERROR: Type or package ZSUSER.INV was not found in the database
[Updated on: Mon, 20 August 2018 07:13] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: Jpublisher giving error for publish table [message #671280 is a reply to message #671273] |
Tue, 21 August 2018 00:08 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
I know nothing about JPublisher either, but - as Michel has suggested - you're doing something wrong. You do think that you're dealing with a table (which, as you checked, exists in that schema), but Oracle says
oracle.jpub.JPubException: J2T-116, ERROR: Type or package ZSUSER.INV was not found in the database
See? TYPE or PACKAGE (which is what Michel said; a procedure).
Have a look at documentation, I believe it describes how to exactly do what you're trying to.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
