Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Invoking Stored Procedure on a Select Statement
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
![]() |
![]() |