Hi All,
I have a plsql package procedure which pulls data from table into a cursor filtered by last_run_datetime and sysdate. This data gets written into a csv file.
Question. I want to store and update the last_run_datetime each time somewhere (preferably not in table) and accessible each time the procedure runs.
Also, want to know what are the implications if there is a database restart/outage on last_run_datetime.