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: Xavier Neys <xavier.neys_at_12move.nl>
Date: Tue, 21 Aug 2001 13:06:34 +0200
Message-ID: <9ltf1l$n0j$2@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 - 06:06:34 CDT

Original text of this message

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