Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> external calls from Triggers

external calls from Triggers

From: Robbie Tischer <rtischer_at_concept5.com>
Date: 1997/09/29
Message-ID: <343060F3.4E43CFD5@concept5.com>#1/1

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
--------------------------------------------------------
Received on Mon Sep 29 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US