Re: Converting LONG to CHAR

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 23 Nov 1999 22:28:26 -0000
Message-ID: <943396194.14761.1.nnrp-09.9e984b29@news.demon.co.uk>

Depends on how you want it done.
In 7.3.4 look at dbms_sql, this version (and possibly a couple earlier) have a:

    dbms_sql.define_column_long
    dbms_sql.column_value_long
which allows you to read a long (not long raw) in chunks. This allows you to write PL/SQL like

    loop

        dbms_sql.column_value_long(
            m_cursor_id,
            m_column_id,
            m_requested_length
            m_offset,
            m_result,
            m_fetched_length
        );
        -- do something with the piece if it is non-zero length
        if m_fetched_length < m_requested_length then
            exit;
        end if;
        m_off_set := m_offset + m_requested_length;

    end loop;

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

gthollingsworth_at_gpu.com wrote in message <81e8mu$tpe$1_at_nnrp1.deja.com>...
>Is there an easier way to convert data from LONG to CHAR or VARCHAR2
>datatype other than using SQLLoader? Using Oracle 7.3.4. Any
>suggestion appreciated (but I think I'm stuck doing it this way).
>
>Thanks
>Jerry
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Tue Nov 23 1999 - 16:28:26 CST