Q: dbms_lob.write ?

From: <tedchyn_at_yahoo.com>
Date: Mon, 28 Jun 1999 19:05:25 GMT
Message-ID: <7l8h1b$pif$1@nnrp1.deja.com>

sir, why am I getting following errors for dbms_lob.write ?

Thanks, Ted Chyn(tedchyn_at_yahoo.com)
SQL> l
  1 declare
  2 lobloc clob;
  3 buffer varchar2(32000);
  4 amount number := 20;
  5 offset number :=1;
  6 begin

  7       buffer :='abcdefghijklmnopqrstuvwxyz';
  8       amount := length(buffer);
  9       dbms_output.put_line(buffer);
 10       dbms_output.put_line(to_char(amount));
 11       select document into lobloc from lob_store
 12          where lob_id =1 for update;
 13        dbms_lob.write(lobloc,amount,1,buffer);
 14       commit;

 15* end;
SQL> desc lob_store

 Name                            Null?    Type
 ------------------------------- -------- ----
 LOB_ID                                   NUMBER(3)
 VIDEO_CLIP                               BLOB
 DOCUMENT                                 CLOB
 SOME_FILE                                BINARY FILE LOB

SQL> /
abcdefghijklmnopqrstuvwxyz
26
declare
*
ERROR at line 1:

ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.DBMS_LOB", line 526
ORA-06512: at line 13

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jun 28 1999 - 14:05:25 CDT