Path: utzoo!utgpu!news-server.csri.toronto.edu!mailrus!ncar!ico!auto-trol!micdel
From: micdel@auto-trol.UUCP (Michael Del Toro)
Newsgroups: comp.databases
Subject: ORACLE PRO*C dynamic SQL problem
Message-ID: <843@auto-trol.UUCP>
Date: 12 Apr 90 17:30:36 GMT
Reply-To: micdel@auto-trol.COM (Michael Del Toro)
Organization: Auto-trol Technology, Denver
Lines: 26

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 !!