DevOps, CI/CD and Automation

Hi,

I'm using Oracle External Procedures with C# as shown here:
http://microsoft.apress.com/asptodayarchive/73976/writing-oracle-external-procedures-with-managed-code


So I've created Managed C++ wrapper ot the C#'s assembly and exposed the reqired methods as C++ functions.
The problem is that when I call the C++ functions within a PL-SQL query, the C#'s assembly that is
referenced in the C++ dll cannot be found. I tried referencing the C++ dll into a VC++ 6.0 project and
everything works fine: the C#'s code has been executed. After that I added the C#'s assembly to the GAC
and then I achieved the desired effect: the C#'s code was executed from a PL-SQL Query. But after removing
the dll from the GAC and restarting the Oracle Listener thing's went back to "normal" - C#'s assembly not found.
The process loading and executing the dll withing a PL_SQL query is extproc.exe which is running as System.




Finally my question:

Is there a way to call an oracle external procedure without adding the wrapped assembly to the GAC?

Maybe it's a matter of right oracle listener configuration or VC++ reference.
Environment: Visual Studio 2005 Team Suite and Oracle 10g.



Thanks!