Meaningless Drivel is fun!
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

Win a copy of Make it so: Java DB Connections & Transactions this week in the JDBC forum!
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
It's not a secret anymore!