1 Reply Latest reply: Mar 28, 2013 4:42 PM by 999864 RSS

    java.sql.SQLException: Invalid empty lob operation

    roaldx
      I have a java source based stored function in which I try
      to build a BLOB. Essential this is what I do:

      1: oracle.sql.BLOB result = oracle.sql.BLOB.empty_lob();
      2: byte[] bytes = new byte[ length ];
      3: bytes = do_something();
      4: result.putBytes( 1 , bytes )

      the java.sql.SQLException happens as a result of line 4.
      I have a wage understanding of what this exception is trying
      to say, but can someone tell me what I need to do????

      Btw.: What is the best reference documentation for the
      oracle.sql classes???

      :-) Roald