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

Home -> Community -> Usenet -> c.d.o.misc -> Displaying LONG column via DBMS_OUTPUT

Displaying LONG column via DBMS_OUTPUT

From: Robert C. Rogers, Jr. <gator90_at_mindspring.com>
Date: Mon, 09 Aug 1999 22:26:28 -0500
Message-ID: <37AF9BE3.1C9CC988@mindspring.com> 






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.

Received on Mon Aug 09 1999 - 22:26:28 CDT












Original text of this message













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