File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Stored Procedures Having Object
 
Similar Threads
passing an array of objects to stored proc(Oracle)
trying to get rows to ResultSet with CallableStatement and stored function
Error executing Oracle function from JSP page
wrong number or types of arguments in call to 'P_RETRIEVE_OPPTY_ORDER_STATUS'
Registering IN OUT parameter