ArrayDescriptor - SqlException

[Arulanand Dayalan]

Hi,

I am struck with this issue.I am creating an ArrayDescriptor,
ArrayDescriptor objArrDesc = ArrayDescriptor.createDescriptor("PRD_SGMN", con);
i am getting the following exception.Has anyone come across it?


java.sql.SQLException: Fail to construct descriptor: Unable to resolve type: "TEST.PRD_SGMN"
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.sql.ArrayDescriptor.initPickler(ArrayDescriptor.java:1776)
at oracle.sql.ArrayDescriptor.<init>(ArrayDescriptor.java:272)
at oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:196)
at oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:165)
at oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:150)
at oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:115)

Thanks in Advance.

Regards,
Arul.

[Scott Selikoff]

ArrayDescriptor are not JDBC, its specific to Oracle so moving this to the Oracle forum..

[Sunil Vasudevan]

Run the following SQL on your Oracle database:
desc PRD_SGMN;

If it returns "ERROR: object PRD_SGMN does not exist", then you do not have this user defined type created in Oracle database. It is then a database issue rather than a java code issue.

Let me know what you find...

[sri ni]

I am facing same problem. when I do a desc <object>, I get the output correctly.

but I still get below exception
Exception in thread "main" java.sql.SQLException: Fail to construct descriptor: Unable to resolve type: "SMSREQ.ACTIONPRIORITY"
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)