RE: BUFFER OVERFLOW, LIMIT OF 2000 BYTES.[Scanned]

From: Karthikeyan S <skarthik_at_globalsw-in.com>
Date: Tue, 24 Sep 2002 22:03:18 -0800
Message-ID: <F001.004D87AD.20020924220318@fatcity.com>

-----Original Message-----
From: Meomeo Nguyen [mailto:meomeo22@yahoo.com]
Sent: Tuesday, September 24, 2002 10:23 PM
To: Multiple recipients of list ORACLE-L
Subject: BUFFER OVERFLOW, LIMIT OF 2000 BYTES.[Scanned]

Hi All,

Below is a script to retrieve data from BFILE column and its output.  The external PDF file is around 53, 435 bytes (text and picture altogether in one file).  Anyone please have a fix for this script.  I am unable to view the content of the external PDF file on the sreen.  Any help is greatly appreciated.

Thanks alot

Lenka

set serveroutput on
DECLARE
  v_book_file  BFILE;
  v_length     NUMBER;
  v_position   NUMBER;
  v_piece      RAW (56,320);
BEGIN
  SELECT book_file
  INTO   v_book_file
  FROM   my_book_text
  WHERE  file_desc = 'testing';
  dbms_lob.open (v_book_file, );
  v_length := dbms_lob.getlength (v_book_file);
  v_position := 1;
  LOOP
    EXIT WHEN v_position > v_length;
    v_piece := dbms_lob.substr (v_book_file, 100, v_position);
    dbms_output.put_line (utl_raw.cast_to_varchar2(v_piece));
    v_position := v_position + 100;
  END LOOP;
  dbms_lob.close (v_book_file);
END;
/
==================

%PDF-1.3
%bcOS
1 0 obj
<<
/Creator
<feff001b7a68001b004d006900630072006f0073006f006600740020005700
6f007200640020>
/CreationDate (D:19991019160202)
/Title
<feff001b7a68001b003600310031003700700062006
30031002e005000440046>
/Author
<feff001b7a68001b0052006f006200650072007400630075>
/Producer (Acrobat
PDFWriter 4.0 for Windows)
/ModDate (D:20001019200402+08'00')
>>
endobj
2 0
obj
[
/PDF /Text /Ima
geB
]
endobj
3 0 obj
<<
/Pages 5 0 R
/Type /Catalog
/DefaultGray 31 0 R

/DefaultRGB 32 0 R
>>

endobj
4 0 obj
<<
/Type /Page
/Parent 5 0 R
/Resources << /Font << /F1 8 0 R
/F2 10 0 R /F0 6 0
R /F3 14 0 R /F4 16 0 R >>
/ProcSet [ /PDF /Text /ImageB ] >>
/Contents 57 0 R

>>
endobj
5 0 obj

<<
/Kids [ 4 0 R 18 0 R ]
/Count 2
/Type /Pages
/MediaBox [ 0 0 612 792 ]

>>
endobj
6 0 obj
<
<
/Type /Font
/Subtype /TrueType
/Name /F0
/BaseFont /Arial
/FirstChar 31

/LastChar 255
/Widt
hs [ 750 278 278 355 556 556 889 667 191 333 333 389 584 278 333 278 278
556
556 556 556 556 556 55
6 556 556 556 278 278 584 584 584 556
1015 667 667 722 722 667 611 778 722 278
500 667 556 833 722
778
667 778 722 667 611 722 667 944 667 667 611 278 278 278 469 556
333 556
556 500 556 556 278 55
6 556 222 222 500 222 833 556 556
556 556 333 500 278 556 500 722 500 500 500
334 260 334 584 750
556 500 500 500 500 500 500 500 500 500 500 500 500 500 500 500
500 500 500 500
500 500 500 500 500
500 500 500 500 500 500 500
500 500 500 500 500 500 500 500 500 500 500 500 500
500 500 500
500 5
00 500 500 500 500 500 500 500 500 500 500 500 500 500 500
500 500 500 500 500
500 500 500 500 500
DECLARE
*ERROR at line 1:
ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
ORA-06512: at "SYS.DBMS_OUTPUT", line 91
ORA-06512: at "SYS.DBMS_OUTPUT", line 58
ORA-065! ! 12: at line 17

---

Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Karthikeyan S
  INET: skarthik_at_globalsw-in.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Wed Sep 25 2002 - 01:03:18 CDT