Re: How long are my LONGs?

From: <sstephen_at_us.oracle.com>
Date: Wed, 21 Oct 1992 21:27:07 GMT
Message-ID: <1992Oct21.132707.1_at_us.oracle.com>


In article <BwFL21.2py_at_well.sf.ca.us>, mharper_at_well.sf.ca.us (Michael J. Harper) writes:
> Now that I have added my solitary LONG column to a table, is there a way
> to find out how LONG the data is on a per row basis? Silly me, I thought
> I could use something like LENGTH() or VSIZE(), but both choke when given
> the name of a LONG column. I am looking for the length of the *actual data*,
> not the maximum length of a LONG column.
>
> Any other thoughts?
>
> Michael J. Harper
> mharper_at_well.sf.ca.us

-- 

   Under V6, the only way to detect the length would be to select the column
into a variable, then check the length field.  It is for this very reason that
SQL*Forms and SQL*ReportWriter, which use LONG columns, also store the length
of data in the row when it stores the value.


================================================================================
Scott Stephens				inet:	sstephen.us.oracle.com
Oracle WorldWide Support                Redwood City, California
Received on Wed Oct 21 1992 - 22:27:07 CET

Original text of this message