Re: C# and Oracle...

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Fri, 11 Mar 2005 19:49:39 -0800
Message-ID: <yIudndn2O5Vy-6_fRVn-pA@comcast.com>

"Adam Norris" <spam_at_slufact0ry.com> wrote in message news:0ck4311ie1sokf3ik772r5f6ugukoi0m7m_at_4ax.com...
> 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. Note that this library is going to be database
> unaware...it is just going to be used to format the file in a
> consistent manner across multiple installations.
>
> 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.
>
> Any other ideas will be GREATLY welcomed...
>
> Thank You
> Adam

You can go to otn.oracle.com and read the document on external procedure calls. They provide examples and the steps to set it up. You can even have it call back into Oracle. Basically, you have to wrap the calls in pl/sql and have it registered as an external process. Jim Received on Fri Mar 11 2005 - 21:49:39 CST