This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach 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 Murach's Java Servlets and JSP this week in the Servlets 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
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