Results 1 to 2 of 2
Thread: SQL Exception from Java program
- 10-28-2008, 05:10 PM #1
Member
- Join Date
- Oct 2008
- Posts
- 11
- Rep Power
- 0
SQL Exception from Java program
Hi
I am getting this exception when I am invoking stored procedure through java program.
java.sql.SQLException: ORA-20000: ERROR -911: ORA-00911: invalid character
ORA-06512: at "PDREPADM.RUN_EXTRACTION", line 119
program :
sql_extraction_sp = "{CALL pdrepadm.Run_Extraction(?,?,?,?)}";
cs_extraction_sp = (OracleCallableStatement) objConnection.prepareCall(sql_extraction_sp);
cs_extraction_sp.setString(1,strQueue);
cs_extraction_sp.setInt(2, iPartition);
cs_extraction_sp.registerOutParameter(3, OracleTypes.CLOB);
cs_extraction_sp.registerOutParameter(4, OracleTypes.NUMBER);
rset = cs_extraction_sp.executeQuery();
System.out.println(" Resultset :" + rset);
Clob clob = cs_extraction_sp.getClob(3);
System.out.println("clob :" + clob);
BufferedReader reader = new BufferedReader(clob.getCharacterStream());
String line = null;
while (( line = reader.readLine()) != null)
{
System.out.println(line);
}
reader.close();
- 10-28-2008, 06:27 PM #2
Member
- Join Date
- Oct 2008
- Posts
- 11
- Rep Power
- 0
Similar Threads
-
SQL Exception from java program
By jyotigupta6 in forum New To JavaReplies: 3Last Post: 10-27-2008, 06:35 PM -
hai friends i got the Exception in the following java program , how do i resolve it ?
By burepallisri in forum Advanced JavaReplies: 3Last Post: 04-07-2008, 05:56 PM -
How to execute an External Program through Java program
By Java Tip in forum java.ioReplies: 0Last Post: 04-04-2008, 02:40 PM -
Trouble with factory method - unhandled exception type Exception
By desmond5 in forum New To JavaReplies: 1Last Post: 03-08-2008, 06:41 PM -
How to execute an External Program through Java program
By JavaBean in forum Java TipReplies: 0Last Post: 10-04-2007, 09:33 PM


LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks