Length of VARCHAR2 fields

From: Zekl <hz_at_tonbeller.com>
Date: 1997/10/23
Message-ID: <NEWTNews.877595439.9387.hz@pc>#1/1

Hello,

I have an apllication in C reading data from Oracle tables. The program has been compiled using the Oracle precompiler Pro*C. The Programm uses dynamical SQL. Values are fetched using a SQLDA structure. My problem is to get the actual lenghth of VARCHAR2 data duroing FETCH. Before FETCH I store the maximum lenght of the data in the length element of the SQLDA. If I read a value which is shorter than this value Oracle always fills the buffer with padding blanks. The length element in the SQLDA remains unchanged.

Does anyone know a solution for this problem ?

Thank you

Dr. Hans Zekl
Ton Beller GmbH
Email: hz_at_tonbeller.com Received on Thu Oct 23 1997 - 00:00:00 CDT