Re: How can i coll a procedure in a function

If those functions are embedded/used in selects: without any doubt If they replace direct inserts and updates (so the end-user has no insert/update/delete access to the table other than through those functions) : no problem.
If those functions implement business rules/controlled redundancy: again no problem.
However, if have the feeling the first scenario occurs more frequently than desired and that scenario will invariably end up in a mess.

Regards

"Bliss" <bliss_is_ignorance_at_hotmail.com> wrote in message news:3bf7b235_2_at_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 - 09:47:06 CST