Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Oracle BLOB

Oracle BLOB

From: frederic servais <frederic.servais_at_advalvas.be>
Date: Wed, 25 Aug 1999 09:38:49 +0200
Message-ID: <7q06df$ljk$1@news0.skynet.be>


I'm trying to fill in a Blob with varchar2 but allways get the following error (in Oracle 8.05):

SQLWKS> declare
     2> ablob blob;
     3> astrid varchar2(14);
     4> len binary_integer;
     5> poss integer := 1;
     6> BEGIN
     7> len := length(astrid);
     8> dbms_lob.write(ablob, len, 1, astrid);
     9> END;
    10> /
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.DBMS_LOB", line 518
ORA-06512: at line 8

any idea Received on Wed Aug 25 1999 - 02:38:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US