help needed: insertion in OCI

Hi,

        I'm posting this message here since I don't know exactly where to post. Pls let me know if this is not the right place, and where to post it.

        I'm trying to insert into a 'LONG' column using OCI calls. I've defined my data in OCI's 'text' datatype, which is unsigned char. I've tried specifying the ftype parameter to 'obndrv' call as SQLT_STR , SQLT_CHR. I get the following error at runtime in 'oexec' call in both cases:

        ORA-01401: inserted value too large for column

The value I'm inserting is just 26 chars long. The 'progvl' parameter to 'obndrv', giving the size of the insertion value, is 27. I also tried with values 26, <large value> etc. I still get the same error. What could be the problem?  

-- 
regards,
Palaniappan 
                                              ~\\\~
                                             (`O-O')
________________________________________.oOo__( ^ )__oOo._____


|                             |                              |

|  Palaniappan N              |    Phone :                   |

|  HP India S/w Operation     |      080 2251554 x1232       |

|  30, Cunningham Road        |    Email :                   |

|  Bangalore 560052           |      npal_at_india.hp.com       |

|                             |                              |

|------------------------------------------------------------|
|___________________________________________.oooO___Oooo.____|
                                            (   )   (   )
                                             \ (     ) /
                                              \_)   (_/