File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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: 195

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!