dbms_lob.writeappend problem

From: <cvulpe_at_linux.pathos.ro>
Date: Mon, 21 May 2001 08:17:41 -0700
Message-ID: <F001.00309493.20010521081608@fatcity.com>

Hi!    

  I have the following problem: I create a procedure where I use dbms_lob.writeappend function:

CREATE OR REPLACE PROCEDURE kelu.append_to_blob(name_of_index VARCHAR2, amt BINARY_INTEGER, buffer RAW) AS
BEGIN
DECLARE
lob_loc BLOB;
begin

        SELECT app_blob INTO lob_loc FROM for_append WHERE app_name=name_of_index FOR UPDATE;
        dbms_lob.writeappend (lob_loc, amt, buffer); end;
END;
/

I use that procedure in a java application:

                Statement stmt = con.createStatement(); 
                CallableStatement cstmt = con.prepareCall("{call 
append_to_blob(?,?,?)}"); 
                 
                String str = "this is the first string written in this database"; 
                 
                cstmt.setString(1,"vvv"); 
                cstmt.setInt(2,str.length()); 
                cstmt.setBytes(3,str.getBytes()); 
                 
                System.out.println(cstmt.executeUpdate()); 

and I get the following exception:

java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: invalid LOB locator

specified: ORA-22275 
ORA-06512: at "SYS.DBMS_LOB", line 715 
ORA-06512: at "KELU.APPEND_TO_BLOB", line 7 
ORA-06512: at line 1 
  
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)  
        at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)  
        at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)  
        at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)  
        at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)  
        at 
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)  
        at 
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)  
        at 
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)  
        at 

oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)   

        at Test_append.main(Test_append.java:28)

What am I missing where?
Best regards,
Vulpe Cristian
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: cvulpe_at_linux.pathos.ro

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon May 21 2001 - 10:17:41 CDT