newbie ProC insertion question

Hello Oracle Gurus,
I've been trying to get a page of ascii into an oracle table for a couple of days with no success. The field in the table is a "long", and I'm using a varchar[12800] pseudotype as a host variable. My declaration reads:

varchar SOW_TEXT[12800]; /* 2 pages of text */

I dereference the string with:

SOW_TEXT.len = strlen(EF4_DOC->SOW_TEXT);

strncpy(SOW_TEXT.arr, EF4_DOC->SOW_TEXT,SOW_TEXT.len);

I then insert it with:

        EXEC SQL INSERT INTO STATEMENT_OF_WORK(SOW_TEXT)         VALUES(:SOW_TEXT); (other items omited for the sake of brevity)

SOW_TEXT in the STATEMENT_OF_WORK table is the "long".

This runs without sqlerrors, but inserts only 80 characters of the host variable. Any insight on this problem will be greatly appreciated.

thanks for your time,

Vince Calcaterra
DSTI Crystal City VA. Received on Fri Feb 03 1995 - 21:36:47 CET