my dog learned polymorphism*
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 Android Security Essentials Live Lessons this week in the Android 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).]
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Help
 
Similar Threads
Problem calling IN parameters Stored Procedure from Java
Determine the Callable Statements Parameters at runtime
Calling Oracle Stored Procedure which has parameter as CURSOR
Urgent
registerOutParameter Problem when the type is ARRAY