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

I believe the answer to the original question is thay you cannot perform any SQL functions on a long column in SQL*PLus or PL/SQL. Thw work around has traditionally been to do whatever it is you're trying to do in a Pro*C routine because you can then manipulate the long column as a large variable containing lots of text.
Regards,
-- Phill --

acresr_at_cnwl.igs.net wrote in message <3698a6c8.6740979_at_news.igs.net>...
>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 Wed Jan 13 1999 - 03:13:01 CET