| 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 |
aruna_a
Messages: 1
Registered: August 2005
|
Junior Member |
|
|
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.
Current problem:
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.
Thanks
Regards
Aruna
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
