Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: procedure call with select srarement?
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:02:08 CDT