micdel@auto-trol.UUCP (Michael Del Toro) (04/13/90)
I would like to accomplish the following using ORACLE'S PRO*C: 1- a dynamic INSERT routine 2- a dynamic SELECT routine 3- a dynamic UPDATE routine 4- a dynamic DELETE routine I would like to create a string of the actual SQL statement, pass it to the appropriate routine and receive any information back (if needed) in another character string. This method appears to work fine when only ONE cursor per module is allocated. (According to the ORACLE PRO*C user's guide, only one cursor can be active per compiled module.) Therefore, I cannot insert data into several different tables at the same time if I need more than ONE active cursor. I believe ORACLE can manage only one SQLCA data structure at a time. Has anybody ever attempted this ?? Am I trying to do something that is impossible ?? Is there another way that I can accomplish this ?? Thanks for your help. -- Michael 'DT' Del Toro Auto-trol Technology Corporation - Denver, CO The Broncos will be BACK in 1991 !!