set serveroutput on size 1000000
(I think thats the max)
Iain Nicoll
-----Original Message-----
Sent: Tuesday, September 24, 2002 5:53 PM
To: Multiple recipients of list ORACLE-L
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 <http://rd.yahoo.com/evt=1207/*http://sbc.yahoo.com/>
Access from SBC & Yahoo!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nicoll, Iain \(Calanais\)
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
