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 -> Re: procedure call with select srarement?

Re: procedure call with select srarement?

From: Yann CAUCHARD <yann.cauchard_at_spcconsultants.com>
Date: Tue, 21 Aug 2001 14:02:08 +0200
Message-ID: <9ltiqh$4c8$1@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:02:08 CDT

Original text of this message

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