Home -> Usenet -> comp.databases.oracle -> How do I read the contents of a LONG field?

How do I read the contents of a LONG field?

From: BEVERLY SEAVEY <nmrdb_at_vms.macc.wisc.edu>
Date: 21 APR 93 09:32:29
Message-ID: <1993Apr21.143632.11783_at_macc.wisc.edu> 






   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. 
Received on Wed Apr 21 1993 - 09:32:29 CEST












Original text of this message