Re: Bug when dividing an INTERVAL

From: gazzag <gareth_at_jamms.org>
Date: 13 Jun 2006 06:06:12 -0700
Message-ID: <1150203972.481874.242870@p79g2000cwp.googlegroups.com>

Mark C. Stock wrote:
> no problems here:
>
> SQL> ed
> Wrote file afiedt.buf
>
> 1 CREATE OR REPLACE PROCEDURE Sp_Bug_Test
> 2 AS
> 3 v_count NUMBER;
> 4 v_view_periode INTERVAL DAY(9) TO SECOND(6);
> 5 v_base_span INTERVAL DAY(9) TO SECOND(6);
> 6 BEGIN
> 7 v_count := 1;
> 8 dbms_output.put_line('v_count: ' || v_count);
> 9 v_base_span := v_view_periode / 1;
> 10 dbms_output.put_line('v_count: ' || v_count);
> 11* END Sp_Bug_Test;
> SQL> /
>
> Procedure created.
>
> SQL> set serveroutput on
> SQL> exec sp_bug_test
> v_count: 1
> v_count: 1
>
> PL/SQL procedure successfully completed.
>
> SQL> select * from v$version
> 2 /
>
> BANNER
> ----------------------------------------------------------------
> Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
> PL/SQL Release 10.2.0.1.0 - Production
> CORE 10.2.0.1.0 Production
> TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
> NLSRTL Version 10.2.0.1.0 - Production
>

Ah, thanks Mark. I got the same results as yourself:

SQL> l
1 CREATE OR REPLACE PROCEDURE Sp_Bug_Test 2 AS

  3          v_count                 NUMBER;
  4          v_view_periode          INTERVAL DAY(9) TO SECOND(6);
  5          v_base_span             INTERVAL DAY(9) TO SECOND(6);
  6  BEGIN
  7          v_count   := 1;
  8          dbms_output.put_line('v_count: ' || v_count);
  9          v_base_span := v_view_periode / 1;
 10          dbms_output.put_line('v_count: ' || v_count);

11* END Sp_Bug_Test;
SQL> / Procedure created.

SQL> set serveroutput on
SQL> exec sp_bug_test
v_count: 1
v_count: 1

PL/SQL procedure successfully completed.

SQL> select * from v$version;

BANNER

Oracle Database 10g Release 10.2.0.1.0 - Production PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production NLSRTL Version 10.2.0.1.0 - Production Received on Tue Jun 13 2006 - 08:06:12 CDT