Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> How to dbms_output LONG

How to dbms_output LONG

From: Holman, Rodney <rodney.holman_at_lodgenet.com>
Date: Tue, 12 Dec 2000 16:21:26 -0600
Message-Id: <10708.124394@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US