Thanx
Bliss
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:tvfrq32v1kamf8_at_corp.supernews.com...
> 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 Mon Nov 19 2001 - 10:56:25 CST
