Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: procedure call with select srarement?
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...Received on Tue Aug 21 2001 - 06:06:34 CDT
>
> Hi,
> i have a question about procedures? Can i call a procedure with a select
> statement?
> When yes why?
>
> --
> Jörg Fischer
>
>
>
![]() |
![]() |