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!

DBMS output for 70000 character string

Naga_SrinivasSep 18 2017 — edited Sep 19 2017

Hi All,

I got a requirement that I need to print 70000 character string using dbms output command In sql plus or pl/sql block.

When I tried , I got oracle error numeric or value error .

when I tried using set linesize 70000 command before I execute my code, I got error with message oracle maximum linesize allowed is 32767 only.

So guys any idea to print a clob string which is 70000 characters size In oracle sqlplus using dbms_output command.

Please help.Thanks.

With Regards,

Srinivas.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 17 2017

Added on Sep 18 2017

12 comments

1,650 views