Hello everybody, I'm very new to this forum and I would like to submit you a question.
I got some big problem on fetching values - inserting values from an oracle Db (input) to another (output).
I'm using Pro*C, and the tables both in Dbin and DbOut, have the same features.
The issue comes when i'm trying to insert the values at dbOutput: it seems to run fine when retrieves/writes
the first record, then it HANGS, without returning me any useful information, such as runtime errors or Oracle error.
I thought it could be that, when i'm tring to retrieve the datas for the second time (inner-loop fetch), i'm
doing it wrong, perhaps i need to clean the struct before inserting new values on it.
The second idea is that i'm suddenly loosing connection towards the output Db, in fact, when i put the connection
string (EXEC SQL AT dbOutput CONNECT :conn) before the INSERT operation, it works well.
and, oh, forgot to mention that the system is SUN/SOLARIS.
Thank you very much,