Can Oracle and/or SQLServer Triggers be used to fire .NET code?

[VBAHole22]

I was wondering if anyone has experience calling some VB.NET code from within an Oracle trigger. Can this be done? What about on SQLSErver?

 

I would like a proc to be run each time an Oracle Trigger is fired. Would I be able to put some code in the PL/SQL to do this? Or would I have to use the Java interface or something like that?

[Robby]

You can run an EXE from Oracle and SQL Server but I doubt you can run a specific piece of code.

[Joe Mamma]

You can run an EXE from Oracle and SQL Server but I doubt you can run a specific piece of code.

I know in MSSQL you can load a COM object. It is a little hairy, but it is but is possible.

 

You can also build extended stored procedure DLL's. . . even hairier :eek:

 

BTW. This is where Informix rocked!!!

[Nerseus]

You can xpcmdshell (with underscores in the name somewhere) in SQLServer to run any EXE. I would guess Oracle has a similar bit of functionality. BUT, I would strong reccommend NOT using this. Performance alone should be enough to drive you away from this one (it's absolutely horrible on a realworld transactional server).

 

If you just want to run a proc during a trigger, then sure - go for it (that's mostly what it's there for). Generally, you'll have your code right in the trigger since triggers should be fast (do their work and get out quickly).

 

If you need something realtime, go with triggers or a proc. If all your inserts into TableA go through one proc, then you wouldn't need a trigger (for example). If you need something more robust, like an EXE, then I'd suggest logging to a specific table that an EXE can scan periodically (polling).

 

If we knew what you were trying, maybe even more suggestions.

 

-ner