Re: Invoking Stored Procedure on a Select Statement

From: Matthias Gresz <nospam_at_newsranger.com>
Date: Thu, 20 Sep 2001 06:55:50 GMT
Message-ID: <Wpgq7.6990$p77.23203@www.newsranger.com>

In article <43b58913.0109191549.4c273d00_at_posting.google.com>, FaheemRao says...

Hi,

though I might be stoned by all the software engeneers:

A solution may be to set up a function -just returning a constant- that as side effect does the job that your procedure would do or calls your procedure. Keep in mind, that programming with side effects isn't good practice.

Matthias

>
>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 Thu Sep 20 2001 - 01:55:50 CDT