Re: Development Trends in Web and Oracle

Hexathioorthooxalate apparently said,on my timestamp of 14/03/2005 12:56 AM:
>
>
> Come on please. You perform some validation in stored procs and triggers.
> You don't just allow the data to be inserted without checking it do you,
> especially if the external schema is stored procs effectively exposing the
> database through an API ! Only in substandard implementations would you NOT
> check the information.

Apparently, some idiot manager at work has decided we cannot post on the Usenet. Must have been promised a job by you-know-who. <sigh>, some arseholes think they can shut others up... Like I care what him and his "security" cohorts come up with!

Anyways, sorry for delay.
No, we do not perform validations in stored procs and triggers. Try to learn how things are done in a proper database before venting something like that!
I need not write a SINGLE trigger to implement the "validations" you describe as "something new XML brings to the table". That is what a serious database does for you: save you coding all that crap.

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
wizofoz2k_at_yahoo.com.au.nospam