*
The moose likes JDBC and the fly likes Stored Procedures Having Object Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Stored Procedures Having Object" Watch "Stored Procedures Having Object" New topic
Author

Stored Procedures Having Object

Nishant Modak
Greenhorn

Joined: Sep 29, 2006
Posts: 27
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

Joined: Jul 26, 2005
Posts: 189

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


SCJP 5, SCWCD 5
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Stored Procedures Having Object