473,320 Members | 1,926 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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

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
Nov 16 '05 #1
2 1997
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#)
------------------------------------------------------------------------
Nov 16 '05 #2
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 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
Nov 16 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Jan Bols | last post by:
I've been trying to install Oracle 8.1.7 on a fresh Mandrake 9.1 O.S for days, but I'm still not able to get it running. I've tried several install instructions that I found on the internet but no...
4
by: susmita_ganguly | last post by:
Hi I am trying to upgrade from oracle 8i to oracle 9i on the same server ..I don't know much abt migration . Can anyone help me out. Thanks. Susmita
63
by: Nick Palmer | last post by:
Hi all, Is there a DB2 equivilant to Oracle's DB Link functionality ? I have two DB2 databases and I need to get access to the tables in one from the other. In Oracle I would just create a DB...
3
by: Jon Ole Hedne | last post by:
My Access 2002-application need to work with tables from both Oracle and Access. To solve this, I want to run some querys on three views in Oracle and import the results into temporary...
13
by: Chris Botha | last post by:
The machine is running XP Pro with all the latest service packs, etc. I must access an Oracle database so I installed the Oracle client stuff. I can query Oracle from a Windows app, no problem....
2
by: Vinod Sadanandan | last post by:
All, Below listed are the new features in Oracle 11g ,please join me in this discussion to generate a testcase and analyze each of the listed features . Precompilers:...
2
by: Ruslan A Dautkhanov | last post by:
Hello ! I'm about to install O9i on FreeBSD box. uname -a: FreeBSD stat2.scn.ru 5.2.1-RELEASE-p3 FreeBSD 5.2.1-RELEASE-p3 #2: Fri Apr 23 19:19:43 KRAST 2004...
0
by: Jack | last post by:
Training Classes for Oracle10g, 9i, 8i Certification training in Oracle10g and 9i: DBA, Developer, Discoverer. training conducted at your location worldwide. Courseware licensing also available....
0
by: Winder | last post by:
Training Classes for Oracle10g, 9i, 8i Certification training in Oracle10g and 9i: DBA, Developer, Discoverer. training conducted at your location worldwide. Courseware licensing also available....
0
by: sathyguy | last post by:
when i type the below in my RHEL AS 4's Firefox 1.5 http://appsworld.ncc.com:7777/forms/...&form=test.fmx iam getting the below error... The requested URL /forms/frmservlet was not found on...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.