Re: vsize and LONG

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 2 Aug 1999 17:31:45 +0100
Message-ID: <933611839.16349.1.nnrp-02.9e984b29@news.demon.co.uk>

Use dbms_sql and write a function which gets the long one chunk at a time until you've got it all.

Sorry, but it's the only way.

Tip to developers when using longs - copy Oracle Corp. always write the size of the long into a column of the table.

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

Tomás Martinez wrote in message <37A5B4C7.1BBF6A3E_at_gosch.com>...
>
>The function vsize is not allowed for a LONG type.
>How can i find with a PL/SQL function, how many bytes has my LONG-field
Received on Mon Aug 02 1999 - 11:31:45 CDT