ERROR in EXTRACT Function
I have a PL/SQL procedure which extract hour, minute and sencond from a datetime value.
It runs correctlty in oracle 9.1 release, but with oracle 9.2 it generate PLS-00656 error
on HOUR, MINUTE, SECOND
below the instruction :
xnu1:= extract(HOUR from sda2) * 3600;
xnu2:= extract(MINUTE from sda2) * 60;
xnu3:= extract(SECOND from sda2);