Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Stored Procedures Having Object

 
Nishant Modak
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

I have a following SP. on Oracle 10g.

and the NTEMP is defined as a Type

------

I want to invoke this via JAVA. for which I have written the following code.


I get the following error on such usage

java.sql.SQLException: [BEA][Oracle JDBC Driver]Unable to determine the type of the specified object.
SQLSTATE : HY000

Any clues?

Thank You!
 
Prabhakar Reddy Bokka
Ranch Hand
Posts: 197
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You should choose the object of a type supported by your oracle and java.

In your case it is a type of array of strings in java.

For detailed data types accepted by both you can look into java.sql.Types
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic