Re: how to check on the length of a LONG field?

From: Danny Lee <dlee+_at_processa.inf.cs.cmu.edu>
Date: 28 Oct 1999 12:28:07 GMT
Message-ID: <7v9fgn$99r$5_at_goldenapple.srv.cs.cmu.edu>


It won't work with length().
SQLWKS> select length(transcript_text) from transcript

     2>
select length(transcript_text) from transcript

              *
ORA-00932: inconsistent datatypes

In article <7v83mj$e12$5_at_news6.svr.pol.co.uk>, "-=< a q u a b u b b l e >=-" <aquabubble_at_Remove.No.Parma.Ham.Remove.geocities.com> writes:
|> Danny Lee <dlee+_at_processa.inf.cs.cmu.edu> wrote in message
|> news:7v5n7d$als$2_at_goldenapple.srv.cs.cmu.edu...
|> > Hi, ORACLE experts:
|> >
|> > I am using oracle 8.0.5 and developer 2000 2.1.
|> > There is a LONG column in a table, and I want to know the size of that
|> column for every row in the table.
|> > Sometimes the content of the column may go beyond 32k bytes.
|> > How can this be done in PL/SQL under Forms 5.0?
|> >
|> > Thanks in advance.
|>
|> SELECT my_unique_id, LENGTH(long_column)
|> FROM my_table;
|>
|> It wouldn't be very nice though!
|>
|>
Received on Thu Oct 28 1999 - 14:28:07 CEST

Original text of this message