aspose file tools*
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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
 
Similar Threads
registerOutParameter Problem when the type is ARRAY
Calling Oracle Stored Procedure which has parameter as CURSOR
Determine the Callable Statements Parameters at runtime
Problem calling IN parameters Stored Procedure from Java
Urgent