is it possible to capture an insert event in an Oracle database?

[Juan]

I need to do some processing from my app after a row is inserted in an
Orcale db, how can i do that?

Thanks,
Juan.

 

[Cor Ligthert]

Juan,

The oracle guys are mostly in this newsgroup.

Adonet
news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet

Web interface:
http://communities2.microsoft.com/c.../?dg=microsoft.public.dotnet.framework.adonet

Cor

"Juan"

 

[C-Services Holland b.v.]

I need to do some processing from my app after a row is inserted in an
Orcale db, how can i do that?

Thanks,
Juan.

Best way is probably a trigger in the db.

 

[Dino Chiesa [Microsoft]]

Interesting that Oracle has announced CLR support in the Oracle 10g r2. you
will be able to write stored procs in VB or other .NET language. Not sure
if database triggers would also be covered by this. They announced it at
Oracle World in SF this past week.

http://www.oracle.com/technology/products/database/oracle10g/pdf/10gr2_highlights.pdf

-Dino