Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> fixed_Date in Oracle 7.3
Dear All,
We have changed fixed_Date using 'alter system' command. It is reflecting fine in 'sysdate'. But when a database package accessed 'sysdate', it returns initial value of sysdate. New fixed date value is not reflected.
Why does SqlPlus returns a different 'sysdate' and package returns a different 'sysdate'.
I will be grateful for any help.
Regards Received on Fri Feb 28 2003 - 02:24:46 CST