Home » Developer & Programmer » Precompilers, OCI & OCCI » Sending a package name as a parameter in Pro C using some other means than Dynamic SQL
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
Previous Topic: memory fault(coredump)
Next Topic: how to read hard disk serial number
Goto Forum:
  


Current Time: Tue Oct 27 01:48:02 CDT 2020