Re: C# and Oracle...

Took a look at the site...maybe because it's late or something like that...do you happen to have a link to the article I need?

Thanx
--Adam

On Fri, 11 Mar 2005 19:49:39 -0800, "Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote:

>
>"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 Sat Mar 12 2005 - 22:17:28 CST