Adam Norris wrote:
Simply put, does anyone know a way that I can call a C# library's
exposed methods from Oracle PL/SQL?
I am currently working on a data transport between disconnected
networks. One network is using Oracle/Powerbuilder and I am using
C#/SQL...I was hoping to simplify my task by using the same C# library
for the data exchange.
I know that I can use PB10 .NET Datawindow functionality to achieve
this; however, the application might run too slow for this so I want
to provide the option to drop the library in at the Oracle level and
use native triggers to facilitate the data exchange.
Not that I'm aware of. Oracle has promised to include CLR support into
Oracle's core (like it supports Java today), though that's not been
released in any form yet. So this means that either you have to write a
Java wrapper which calls into your C# library outside the RDBMS (though
how to accomplish this is unclear to me, as I'm unaware of sandbox
issues with Java inside Oracle) or move your calls to code outside the
RDBMS, thus call the C# code not in PL/SQL but in your code calling the
PL/SQL as well.
FB
--
------------------------------------------------------------------------
Get LLBLGen Pro, productive O/R mapping for .NET:
http://www.llblgen.com
My .NET blog:
http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------