Re: How do I read the contents of a LONG field?

From: <sharmp_at_hhcs.gov.au>
Date: 27 Apr 93 09:29:53 +1000
Message-ID: <1993Apr27.092953.729_at_hhcs.gov.au>


In article <1r3td6$ojs_at_lll-winken.llnl.gov>, 217092_at_llnl.gov (Jeff Dew) writes:
>

>>   I've been perusing the view definitions that make up the DBA_***
>>views on the system catalog that oracle provides. One of the view 
>>definitions is 591 characters long. From the SQL*DBA utility I can
>>set LONGWIDTH to no more than 500 chars before, during a fetch, I
>>get a complaint about some internal buffer being exceeded. I don't
>>seem to be able to do a datatype conversion to CHAR, which would
>>allow me to do something like SUBSTR(text,500). How do I get to
>>see the rest of the view definition? Not that I care that much about
>>the view, I'm just curious at this point about the proper method for
>>accessing LONGs. 

>
> Try the following settings in your sql*plus session before trying to
> display the view text:
>
> set arraysize 1 /* this should solve you buffer size problem */
> set long 2000
>
> ---
>
> Jeff J. Dew Internet: jdew_at_llnl.gov
> Lawrence Livermore National Lab PacBell Net: (510) 422-2694
-- 
The other thing you need to do to look at the full text of the view (at least
on 6.0.34 on VMS) is enter the following:

SQL> column text wrap

Regards

Peter
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Peter Sharman                                                 SHARMP_at_HHCS.GOV.AU
Aust. Dept Health, Housing and Community Services             06-289 7661
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Received on Tue Apr 27 1993 - 01:29:53 CEST

Original text of this message