PRO-C OS/2 Questions

I'm new to Oracle, have a couple questions about running PRO-C programs under OS/2.

First question - do I need to establish Oracle connection from each thread which accesses
database? Oracle seems not to allow me to establish connection from one thread and
make EXEC SQL calls in a different thread. Even if I could, it seems that the "sqlca" return
area, among other things, are not reentrant. What's the scoop?

Second question - when I execute an EXEC SQL SELECT ... to retrieve items from database,
the items returned seem to be padded with spaces (have tried VARCHAR as well as typedef'ed
null-terminated ASCII strings). I also seem to need to pad variables with spaces if passing a
string to SELECT statement in order to get rows back from the database. Is there any way to
get the database to store strings which don't have this padding?

Thanks in advance...

Charlie Heath Received on Sun Nov 26 1995 - 00:00:00 CET