Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PLSQL - Output a long string to screen

869638Aug 5 2011 — edited Aug 8 2011
I am trying to create an XML file, but I don't have FTP access on the server, only read rights.
So I need to output a long string on the screen.
By using the

DBMS_OUTPUT.PUT_LINE ('<Environment> ' || long_string_01 || long_string_02 || '</Environment>');

I get the 255 buffer error.
Whats the easiest way around it?

Thanks in advance everyone!

Edited by: 866635 on Aug 5, 2011 5:16 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 3 2011
Added on Aug 5 2011
7 comments
2,035 views