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 Help 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 "Help" Watch "Help" New topic


Shiv Sidhaarth
Ranch Hand

Joined: Aug 06, 2001
Posts: 119
I have created this record in package temp.
type rec is record
CID DTmaster.ClassID%Type
end temp;

I created procedure named 'dtm' and called from java thru callable statement. It gave sql exception : Invalid column type, after printing "callable stmt is prepared".
dtm procedure
( test IN OUT temp.rec)
select ClassID into test.cid from DTMaster;
Here is the java code :
CallableStatement cstmt = con.prepareCall(str);
System.out.println("callable stmt is prepared");
cstmt.registerOutParameter(1, java.sql.Types.OTHER);
System.out.println("OUT is registered");;
Can somebody tell me cause and solution please?
[This message has been edited by sankar sv (edited September 03, 2001).]
I agree. Here's the link:
subject: Help
jQuery in Action, 3rd edition