Tag Info

New answers tagged

0

Yes, 'W' will do that -- replace the file. Use 'A' to append. I don't think you can "modify in place"; you might have to copy the file to a new one making the changes you desire, delete the original and then rename the copy. All of this begs the question why you're trying to do all of this in PL/SQL. It might be better -- certainly easier -- to do it in an ...


1

The actions you're performing on the data is technically different between the insert/update portions, but what about the business logic difference? IMO, your best bet is to contain a functional unit of work inside of a trigger, so that there is no discrepancy in what that trigger does. In my experience, Developers/Business Analysts often tend to think in ...


0

The JOB_OVER_MAX_DUR event isn't listed in docs until 11.2, even though MAX_RUN_DURATION is available in versions earlier than that. Compare 11.2 and 11.1. Additionally: DBMS_SCHEDULER.JOB_ALL_EVENTS on 11.2 does not include JOB_OVER_MAX_DUR (despite the name). Setting the RAISE_EVENTS attribute will neither set nor remove the JOB_OVER_MAX_DUR event. ...



Top 50 recent answers are included