This week's book giveaway is in the OCAJP forum.
We're giving away four copies of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) and have Khalid A Mughal & Rolf W Rasmussen on-line!
See this thread for details.
Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Help

 
Shiv Sidhaarth
Ranch Hand
Posts: 119
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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).]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic