Dynamic SQL - proC - Method 4

Hello everybody,

I sent an email few weeks ago about a problem I had with an application accessing an Oracle database with proC by using the Dynamic SQL method 4 ( I included the post at the end of this email).

Some people responded to me and told me to reset datatype codes in the T descriptor array, i.e coercing datatypes. It is what I did to coerce , for instance , the ith select list value to STRING by using the following statement :
select_des->T[i] = 5;

I tried to do it after the DESCRIBE SELECT LIST.

But it isn't working and I still have the same problem.

Has any of you other ideas which could help me to fix this problem? Thank you for your help.

Sylvain.

We developed an application accessing an Oracle database with proC/C++ by using the Dynamic SQL method 4. Currently, our application is written in C and is using some proC statements.

When we want to get some data from the database by using this application, everything works fine except with the "string" fields. Indeed, if the type of one field is varchar(10) and this field contains 4 characters, the Dynamic SQL method 4 will return a string containing 10 characters with the 4 corresponding characters + 6 spaces.

We are thinking there should be a way in proC to take care about this problem.

Has any of you already been confronted to this problem? Thank you for your help.

Sylvain.