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.
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).]