Re: Oracle 7 Pro*C code for long > 65533

In article <2d0qms$d2o_at_lll-winken.llnl.gov>, coffey1_at_llnl.gov (Stu Coffey) writes:
> Hi,
>
> I need to insert and select a field of datatype long that is > 65K. As indicated in the Pro*C supp. the largest varchar is 65K. Could someone point me in the
> right direction for getting code or information that allows this access of a long under oracle 7.
>
> ---
> ----------------------------------------------------------------------------
> ___ ___ ___ ___ ___ | Stuart Coffey
> /_ /| /_ /| /_ /\/_ /| /_ /| | Lawrence Livermore National Lab
> | | | | | | | \ | | | | | | |
> | | |___ | | |___ | \ | | | | | |___ | Internet: coffey1_at_llnl.gov
> | |/__ /| | |/__ /| | \ \| | / | |/__ /| | Fax: (510) 422-3396
> |_____|/ |_____|/ |_|\___|/ |_____|/ | Voice: (510) 422-6938
>
>
>

You can use datatype equivalencing, for example (forgive the COBOL):

           EXEC SQL BEGIN DECLARE SECTION END-EXEC.
               01  JOAN-REC-VARS.
                   05  C5            .
                     49  C5-LEN         PIC S9(8) USAGE COMP.
                     49  C5-TEXT          PIC X(100000).
           EXEC SQL VAR C5 IS LONG  VARCHAR(100000) END-EXEC.
           EXEC SQL END DECLARE SECTION END-EXEC.