How
to get sysdate in a store procedure?
I don't believe you need to
use dual in PL/SQL to get to sysdate or user
etc. You can also use
date functions directly.
You can simply assign sysdate
to a PL/SQL variable.
temp_date := add_months(last_day(sysdate)
+1, -1);