Re: LONGS - anyway to split them up (other than SUBSTR)??
Date: 1996/02/18
Message-ID: <4g89cb$h5m_at_gossamer.itmel.bhp.com.au>#1/1
In article <charless.255.0009FC87_at_umich.edu>, charless_at_umich.edu (Charles E. Swift) says:
>
>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
We are using Longs, and associate with it a multi-record text file
that is VARCHAR2(80s) (+ keys, of course)
This lets the user edit into the LONG and report from the multi-record
(we arent using Oracle*Report, but SAS and Business Objects, instead,
neither of which can handle Longs)
We have a C program which is called from a trigger on the table
holding the Long (cant remember what trigger) that writes into
the multi-record table upon update and the whole thing works like a
dream - we havent had to look at it since it was written, and it means
that we never have to worry about selecting from Longs, we just
access the multi-record table where we need to manipulate the long
Lee
------/\/\------+---------------------------------------------------
/ / /\ | Lee Levy, ISSD Systems Development, Del Code (34)
/ / / \ | BHP Information Technology, ACN 006 476 213
/ / / /\ \ | PO Box 261, Warrawong, NSW 2502, Australia
\ \/ / / / | PH: +61 42 75-5485 Fax: -5500 Tie: 8855-
\ / / / | Internet : levy.lee.ls_at_bhp.com.au
-----\/\/\/-----+---------------------------------------------------Opinions expressed are mostly my own, so give me some credit. Received on Sun Feb 18 1996 - 00:00:00 CET