Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Truncating a LONG column to fit a PL/SQL LONG var

Re: Truncating a LONG column to fit a PL/SQL LONG var

From: Morten <morten_at_kikobu.com>
Date: Wed, 20 Mar 2002 18:40:24 +0100
Message-ID: <3C98C988.5030706@kikobu.com>


Morten Primdahl wrote:
>
> Hi. What are the best practices for truncating a LONG
> column to fit a PL/SQL LONG variable?

PROCEDURE COLUMN_VALUE_LONG(c IN INTEGER,

                     pos IN INTEGER,
                     offset IN INTEGER,
                     value OUT VARCHAR2,
                     val_length OUT INTEGER)

Is what I was looking for :) Received on Wed Mar 20 2002 - 11:40:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US