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>
>
> 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
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