|Sending a package name as a parameter in Pro C using some other means than Dynamic SQL [message #133891]
|Mon, 22 August 2005 11:14
Registered: August 2005
I am writing a Pro c procedure call using the VC++ IDE. I am trying to pass in a SP package name as a parameter. I am working with an Oracle 9i DB instance.
Every time, we change a SP package name (version number bumped up), we need a recompile since the SP package name has a version number concatenated to it as part of its name. To prevent this complete application recompile, am trying to read in a package name and then call it real time based on what is being sent as input from an INI file.
Am pretty new to Pro C programming. Based on advise from my colleagues, Dynamic SQL takes more processing time when I try to replace the same. I even tried it.
Could you suggest some other way by means I could solve this problem of passing in the SP package name as a parameter in Pro C without eating up processing time?
Look forward to your suggestions.