Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> How to dbms_output LONG
How do you get past the 255 limit on dbms_output in plsql? I'm trying to
dynamically generate some scripts from the data dictionary. However on
dba_views the "TEXT" column which contains the view definition is a LONG.
Some of our views are very long in their definition and when I run my
procedure it fails because of the line overflow of 255.
TIA,
Rodd Holman
Enterprise Data Systems Engineer
LodgeNet Entertainment Corporation
rodney.holman_at_lodgenet.com
Comments made are my own opinions and views. They do not represent views,
policies, or procedures of LodgeNet Entertainment Corporation
Received on Tue Dec 12 2000 - 16:21:26 CST