Re: Oracle 7.3, parsing the contents of a LONG column?

[Quoted] Hi all,

In reviewing past Oracle newsgroup messages, it seems those questions people have had with regard to parsing or extracting data/contents of a LONG column in Oracle have gone unanswered. I am wondering if there is anybody here who knows the answer to this?

I have been trying via Excel (but would find it beneficial in VB6 as well) to call up the contents of a LONG column as part of a query.

Any ideas or pointers would be eXtremely appreciated!

Thanks!

===> Roy
acresr_at_cnwl.igs.net

Guy Starbuck <guy.starbuck_at_syllogistics.com> wrote:

>I want to use a PL/SQL procedure to process the contents of a single
>LONG column. This column will be filled with the contents of a fixed
>format but variable length flat file.
>
>Since you cannot use "substr" or other string parsing functions on a
>LONG column, does anyone know of any SQL or PL/SQL functions which can
>be used to extract sections of a LONG column?
>
>Any help would be appreciated.
>
>Guy Starbuck
>guy.starbuck_at_syllogistics.com
Received on Sat Jan 09 1999 - 21:26:53 CET