This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
I am running a store procedure which is failing after a database upgrade. This has raised two questions. Since I am getting a java exception I would like to run the Stpre Procedure on the SQL pluus editor.
Problem is that the Store Procedure returns a CLOB as a out parameter.
I use the run the following code
BEGIN MISupdate.insertMISP('1004','123','AA123','original','EOY','Y','TPVS','111', '2005-12-10','Microsoft','v101','NIRS','1034','Y','Consolidated','EDI','Indi vidual','1100','28-jun-2004 12:22:13','1','1','106','30','28-jun-2004 12:23:13','28-jun-2004 12:23:13',clobType); END; /
which returns a wrong literal error message. Is this the correct way to call a Store Procedure with a CLOB as an out parameter.
The java exception is as follows:
Exception Class...:java.sql.SQLException Exception Message.:Unsupported feature Failing Class..... racle.jdbc.dbaccess.DBError Failing Method....:throwSqlException Failing File...... BError.java Failing Line No...:134 Previous Exception:null I am updating two timestamps could that be the problem.