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

Home -> Community -> Usenet -> c.d.o.server -> Help! dbms_lob.read for blob datatype

Help! dbms_lob.read for blob datatype

From: <thura_at_my-deja.com>
Date: Thu, 08 Jul 1999 22:41:03 GMT
Message-ID: <7m39dt$pfn$1@nnrp1.deja.com>


Hello,

I'm new to Oracle8 and can't understand why my code is not working. Any help would be appreciated. TAO.

  1 declare

  2     locator_var BLOB;
  3     amount_var  INTEGER;
  4     offset_var  INTEGER;
  5     output_var  VARCHAR2(10);
  6  begin
  7     amount_var := 10;
  8     offset_var := 1;
  9     select proposal_text into locator_var
 10       from pdnowak.proposal2
 11      where proposal_id = 1;
 12     DBMS_LOB.READ(locator_var, amount_var, offset_var, output_var);
 13     DBMS_OUTPUT.PUT_LINE('Start of Proposal text: '|| output_var);
 14* end;
 15 /
declare
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error ORA-06512: at line 12

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 08 1999 - 17:41:03 CDT

Original text of this message

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