Oracle and C#...the other way...

  • Thread starter Thread starter Adam Norris
  • Start date Start date
A

Adam Norris

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.

Any other ideas will be GREATLY welcomed...

Thank You
Adam
 
Adam said:
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.
Click to expand...

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

--
 
Adam said:
Simply put, does anyone know a way that I can call a C# library's
exposed methods from Oracle PL/SQL?
Click to expand...

I wondor if ODP supports DBMS_Alert? I haven't seen any info on this.

I've used a Delphi tool called Direct Oracle Access and this let us
listen for a DBMS_Alert sent from Oracle. This even works accross
platforms - Oracle is running on Solaris.

DMBS_Alert is a simple way to send a short event from the DBMS to a
client program. Once you receive the event you can query the DBMS to
learn more about why the event was sent.

Eric
 
Back
Top