RE: RE: a PL/SQL design question.

2002-12-10 Thread Jamadagni, Rajendra
Title: RE: RE: a PL/SQL design question. Dear Richard, These are a bunch of developers who think they are "GOD" (at-least their managers think so) ... we have learned that it is better to let them try and fail themselves rather than trying to explain them the right thing ... it

RE: RE: a PL/SQL design question.

2002-12-10 Thread Jeremy Pulcifer
Title: RE: RE: a PL/SQL design question. I'd like to add a point here as well... Because DBMS_JOBS are asynch, ie not transaction bound and not read-consistent, by design they should not be allowed to be fired from triggers or other event-driven mechanisms _if_ they are to accomplish