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).]
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads