This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Soft Skills and have John Sonmez on-line!
See this thread for details.
The moose likes JDBC 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 Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Help" Watch "Help" New topic
Author

Help

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)
is
begin
select ClassID into test.cid from DTMaster;
end;
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");
System.in.read();
cstmt.execute();
Can somebody tell me cause and solution please?
Thanks,
Sankar
[This message has been edited by sankar sv (edited September 03, 2001).]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Help