Re: Displaying LONG column via DBMS_OUTPUT

Robert C. Rogers, Jr. wrote:
>
> I am trying to create a PL/SQL script that will, in part, generate a
> VIEW creation script for a specified schema. As such, I am attempting
> to create a cursor that cycles thru ALL_VIEWS and prints the TEXT field
> to he screen. DBMS_OUTPUT.PUT() expects a VARCHAR2 argument...the TEXT
> column is a LONG datatype. Is there a way to display such a column via
> DBMS_OUTPUT (or any other way) in a PL/SQL block?
>
> Thanks in advance.
> Robert.

Yes, you can. You should first fetch your long column into a varchar2 variable. ( a VARCHAR2(32000) will do ) You can display the varchar2 variable using dbms_output.put!

Maarten Received on Tue Aug 10 1999 - 08:46:18 CDT