Results 1 to 2 of 2
  1. #1
    jyotigupta6 is offline Member
    Join Date
    Oct 2008
    Posts
    11
    Rep Power
    0

    Default 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();

  2. #2
    jyotigupta6 is offline Member
    Join Date
    Oct 2008
    Posts
    11
    Rep Power
    0

    Default SQL Exception from java program

    Can anyone help me in this?

Similar Threads

  1. SQL Exception from java program
    By jyotigupta6 in forum New To Java
    Replies: 3
    Last Post: 10-27-2008, 07:35 PM
  2. Replies: 3
    Last Post: 04-07-2008, 06:56 PM
  3. Replies: 0
    Last Post: 04-04-2008, 03:40 PM
  4. Replies: 1
    Last Post: 03-08-2008, 07:41 PM
  5. Replies: 0
    Last Post: 10-04-2007, 10:33 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •