my dog learned polymorphism
The moose likes JDBC and Relational Databases and the fly likes Stored Procedures Having Object Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Stored Procedures Having Object" Watch "Stored Procedures Having Object" New topic

Stored Procedures Having Object

Nishant Modak

Joined: Sep 29, 2006
Posts: 27

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.

Any clues?

Thank You!
Prabhakar Reddy Bokka
Ranch Hand

Joined: Jul 26, 2005
Posts: 193

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

I agree. Here's the link:
subject: Stored Procedures Having Object
It's not a secret anymore!