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: How can i coll a procedure in a function

Re: How can i coll a procedure in a function

From: Bliss <bliss_is_ignorance_at_hotmail.com>
Date: Sun, 18 Nov 2001 21:06:18 +0800
Message-ID: <3bf7b235_2@news.tm.net.my>


Yups, it's not true in 8i.... functions can perform DML's.... but isn't it a bad practise to have functions (directly or otherwise) perform DML's???? comments anyone???

Regards,
Bliss
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:tvfattc9l1cvb3_at_corp.supernews.com...
>
> "Damien Salvador" <damien.salvador_at_via.ecp.fr> wrote in message
> news:slrn9vf2ec.eig.damien.salvador_at_zen.via.ecp.fr...
> > On Sun, 18 Nov 2001 04:09:27 GMT, jane
> > <janeyiu_at_optonline.net> a écrit:
> > >How do you call *any* module in *any* module ?
> > >Just call it in the execution section feeding any required
> > >parametres like...
> > >
> > >procedure_1;
> >
> > Beware, there are traps in calling procedure from functions, as you
cannot
> > do a DML (create table, drop, aso ) in a function, so if I remember
> > correctly, you'll get an error when calling a procedure in a function.
> [snip]
> > --
> > Damien
> >
>
> This is simply _NOT_ true if it is stated _THIS_ generically, and it is
not
> true anymore for 8i
>
>
> Regards
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
>
>
Received on Sun Nov 18 2001 - 07:06:18 CST

Original text of this message

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