Re: Bug when dividing an INTERVAL

"gazzag" <gareth_at_jamms.org> wrote in message news:1150202672.960227.118910_at_h76g2000cwa.googlegroups.com... Björn Wächter wrote:
> When I create this Procedure in my Oracle
> 10.1.0.4 Database and execute it I see the
> strange effect that v_count is changing from
> 1 to NULL. It only happens when dividing
> the Interval by 1.
> Is this Bug known?
> Do you get the same result?
> Is the effect the same in 10.2?
>
>
> CREATE OR REPLACE PROCEDURE Sp_Bug_Test
> AS
>
> v_count NUMBER;
> v_view_periode INTERVAL DAY(9) TO SECOND(6);
> v_base_span INTERVAL DAY(9) TO SECOND(6);
> BEGIN
> v_count := 1;
> dbms_output.put_line('v_count: ' || v_count);
>
> v_base_span := v_view_periode / 1;
> dbms_output.put_line('v_count: ' || v_count);
>
> END Sp_Bug_Test;
>
>
> Björn

>Aren't your two dbms_output lines identical?

They are, but their output isn't. Indeed, the first output is 1, the second is NULL. Verified on 10.1.0.5. Divide by anything else (for example, by 2,) and v_count doesn't change. Strange... Looks like a case for Oracle Support.

-- 
   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)
   http://www.dynamicpsp.com