Home -> Usenet -> comp.databases.oracle -> LONGS - anyway to split them up (other than SUBSTR)??

LONGS - anyway to split them up (other than SUBSTR)??

From: Charles E. Swift <charless_at_umich.edu>
Date: 1996/02/16
Message-ID: <charless.255.0009FC87_at_umich.edu>#1/1 






I realize you cannot SUBSTR a LONG in a SELECT statement, however,
I was able to write a PL/SQL block that reads the data into a 
LONG variable and allowed me to do a SUBSTR on the variable. It
will only give me the first 2000 bytes, however. I assume this
is similar to the problem of using SUBSTR on a LONG in a SELECT
satement. Any way to get around this?? I would like to be able to
search for text on this data. (I am working on a MAC platform where
TEXT*SERVER is not yet available)



Thanks very much!


Charles Swift.



charless_at_umich.edu 
Received on Fri Feb 16 1996 - 00:00:00 CET












Original text of this message