Clob data update problem

[asim chakraborti]

I am trying to update Clob data . Code is as below . When try to run the
code it gives Oracle Exception  ORA01002 .  Could anyone help me about it .

My code --

////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////

    DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

   ////////Insert Operation
   Connection  conn_insert = DriverManager.getConnection (connString,
dbUser, dbPassword) ;
   System.out.println(" Connection ===  "  + conn_insert ) ;
   PreparedStatement insert_pstmt = conn_insert.prepareStatement
    ("INSERT INTO test_lob (IDNUMBER , LOB ) VALUES ( ? ,
empty_clob()    )" ) ;

    insert_pstmt.setInt(1, 1) ;
    insert_pstmt.executeUpdate() ;


    conn_insert.commit() ;
    conn_insert.close() ;

    Connection  conn_update= DriverManager.getConnection (connString,
dbUser, dbPassword) ;

    Statement update_pstmt = conn_update.createStatement( ) ;
    String sql_str = " SELECT LOB  FROM test_lob  WHERE IDNUMBER = " + 1 +"
for update " ;

    OracleResultSet rset_update = (OracleResultSet)
update_pstmt.executeQuery(sql_str) ;

    rset_update.next() ;
    OutputStream os_stream = rset_update.getCLOB(1).getAsciiOutputStream();

   String data_clob = "aaaaaaaaa"   ;
    byte total_buffer[]  = data_clob.getBytes() ;
    os_stream.write( total_buffer, 0, total_buffer.length );
    os_stream.close();

    os_stream.write( total_buffer, 0, total_buffer.length );
    os_stream.close();

    conn_insert.commit() ;
    conn_insert.close() ;


////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////

Exception generated when run
   -----------------------------------------

java.sql.SQLException: ORA-01002: fetch out of sequence

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114) at
oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) at
oracle.jdbc.ttc7.Oall7.receive(Oall7.java:542) at
oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1311) at
oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:797) at
oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1608)
at oracle.jdbc.driver.OracleStatement.doExecute(OracleStatement.java:1758)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java
:1805) at
oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.
java:4810) at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:416) at
ConnectionPoolTest.ClobTestNew.main(ClobTestNew.java:127) Process Exit...





Thanks Asim

___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html