Re: external calls from Triggers

Robbie:

I have the same need. What I understood so far is on Oracle 7 you could use dbms_pipes
to communicate with another non-PL/SQL (Pro*C) process and thereby invoke some processing.

With Oracle 8 there could/should be other possibilities (???)

I would appreciate any posting that help to clarify this

-- 
Timo Feickert - Software Engineer 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
[at work] : Timo.Feickert_at_prompt.de.NOWHERE
[at home] : TransAct_at_compuserve.com.NOWHERE
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
(please remove trailing [.NOWHERE])


Robbie Tischer <rtischer_at_concept5.com> schrieb im Beitrag
<343060F3.4E43CFD5_at_concept5.com>...


> I need to make an external call from an Oracle trigger. Some SQLs have a

> legitimate CALL statement that can be called from the trigger's action

> block. Apparently, Oracle can only call a PL/SQL block, which explicitly

> only operates on ORACLE data, it says. Does anyone know the reason for

> this? And how to get around this?

> 

> --

> --------------------------------------------------------

> Robbie Tischer, Sr Design Engineer rtischer_at_concept5.com

> Concept Five Technologies, Inc.     Tel: (703) 610-1533

> 7525 Colshire Drive, Z677             Fax: (703) 610-1853

> McLean, Virginia 22102-7400        www.concept5.com

> --------------------------------------------------------

> 

> 

>