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

Home -> Community -> Usenet -> c.d.o.misc -> Invoking Stored Procedure on a Select Statement

Invoking Stored Procedure on a Select Statement

From: FaheemRao <faheemrao_at_yahoo.com>
Date: 19 Sep 2001 16:49:57 -0700
Message-ID: <43b58913.0109191549.4c273d00@posting.google.com>


I need to Invoke a stored procedure on as soon as a Select Statement tries to select something from a View.

Triggers as far as my knowledge cannot do that , because triggers can be invoked only by DML(Update,insert, Delete) .

Now any one know that Oracle has something like triggers through that I can ivoke a Stored Procedure on a Simple Select Statement.

Thanks Received on Wed Sep 19 2001 - 18:49:57 CDT

Original text of this message

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