| Author |
ArrayDescriptor -- sql exception
|
sri ni
Greenhorn
Joined: Jul 09, 2008
Posts: 2
|
|
Hi, I am trying to pass object to stored procedure. I get the below error. Can any one provide your feedback please? Exception in thread "main" java.sql.SQLException: Fail to construct descriptor: Unable to resolve type: ".ACTIONPRIORITY" 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:251) at com.inf.db.DAO613.insertService(DAO613.java:53) at com.inf.ui.CM613.main(CM613.java:26) code in the database: create or replace TYPE ActionPriority AS OBJECT ( Action_id NUMBER, Priority NUMBER ); / create public synonym ACTIONPRIORITY for ActionPriority; create or replace procedure testproc ( ap ActionPriority ) IS BEGIN dbms_output.put_line('test'); END; / I can see the description of object in database SQL> desc ActionPriority Name Null? Type ----------------------------------------- -------- ---------------------------- ACTION_ID NUMBER PRIORITY NUMBER SQL> ------------- I am calling stored procedure from standard JAVA application. database : oracle 10G I have oracle 10G classes12.jar, ojdbc14.jar in class path. JAVA code: oracle.sql.ArrayDescriptor desc = new oracle.sql.ArrayDescriptor("ACTIONPRIORITY",con);
|
 |
 |
|
|
subject: ArrayDescriptor -- sql exception
|
|
|