Long fields update

From: kenneth long <klong66_at_yahoo.com>
Date: Mon, 06 Sep 1999 19:16:18 -0800
Message-ID: <3RdB3.1801$Zd.993651_at_WReNphoon3>


Your best bet is to use PL/SQL. Read the value into a varchar dsif the long is less than 64K..

Otherwise you have to write C code. Take a look at the PRO-C doc's on TYPE mapping Here's a sample I've used in the past..

#define LONGVRAW 100000

struct long_buf{

        long  len;
        char  arr[LONGVRAW];
       }  ;

typedef struct long_buf long_vraw;
EXEC SQL TYPE long_vraw IS LONG VARRAW ( LONGVRAW );

   -**** Posted from RemarQ, http://www.remarq.com/?a ****-  Search and Read Usenet Discussions in your Browser - FREE - Received on Tue Sep 07 1999 - 05:16:18 CEST

Original text of this message