Re: procedure call with select srarement?

Yann,

As the name suggest, an instead-of trigger performs your trigger code instead of the statement that triggered it. An example:
You have a view which selects any number of columns from any table. The from clause is not important because the view will not actually be executed. You can even select 10 times the same column with aliases.
The columns serve as parameters to your triggered code. Create an instead of insert trigger on your view and whenever you insert into the view, your code is executed. Oracle will not try to do any kind of insert.
I have seen it used in environment which do not allow you to call stored procedure easily, e.g. in Access97

Hope this helps,
Xavier.

PS: French is my mother language, you can use some with me if you prefer.

"Yann CAUCHARD" <yann.cauchard_at_spcconsultants.com> wrote in message news:9ltiqh$4c8$1_at_news2.isdnet.net...
> What's a view with an instead-of statement ?
>
> Thanks in advance .
>
> Yann
>
> Xavier Neys a écrit dans le message <9ltf1l$n0j$2_at_news1.xs4all.nl>...
> >Hi Jörg,
> >
> >AFAIK you can't call a procedure in a select statement. Use stored
> functions instead.
> >Another trick is to use a view with an instead-of trigger.
> >
> >
> >--
> >Today, Tomorrow, Together
> >The DOC
> >(The Dutch Oracle Company)
> >
> >Xavier.
> >
> >
> >"Joerg.Fischer" <Joerg.Fischer_at_Bsw-kehl.de> wrote in message
> news:3b8225ff$0$241$4dbef881_at_businessnews.de.uu.net...
> >>
> >> Hi,
> >> i have a question about procedures? Can i call a procedure with a select
> >> statement?
> >> When yes why?
> >>
> >> --
> >> Jörg Fischer
> >>
> >>
> >>
> >
> >
>
>
Received on Tue Aug 21 2001 - 07:55:39 CDT