the below procedure works fine in oracle 9i but not in oracle 10g xe.
is the format to specify day to second interval different in oracle 10 G?
declare
v_min NUMBER;
v_sec NUMBER;
time_taken INTERVAL DAY TO SECOND;
begin
v_min:=2.3;
v_sec:=4.7;
time_taken:=TO_DSINTERVAL('0 0:'||TO_CHAR(V_MIN)||':'||TO_CHAR(V_SEC));
end;
SQL> declare
2 v_min NUMBER;
3 v_sec NUMBER;
4 time_taken INTERVAL DAY TO SECOND;
5 begin
6 v_min:=2.3;
7 v_sec:=4.7;
8 time_taken:=TO_DSINTERVAL('0 0:'||TO_CHAR(V_MIN)||':'||TO_CHAR(V_SEC));
9 end;
10 .
SQL> /
declare
*
ERROR at line 1:
ORA-01867: the interval is invalid
ORA-06512: at line 8