Re: Bug when dividing an INTERVAL

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Tue, 13 Jun 2006 11:22:22 -0400
Message-ID: <1qCdncPUFeWvRRPZnZ2dnUVZ_qmdnZ2d@comcast.com>

: "Björn Wächter" <bwc_at_p3-solutions.de> wrote in message
: news:4f7huuF1h44n9U1_at_news.dfncis.de...

:: 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

some additional thoughts:

did you submit a TAR? (will likely be advised to upgrade)

i seem to recall seeing a similar type of bug in the past, and the work-around was to add an extra line of code (don't recall if the code line was in the declare section or near the assignment doing the clobbering -- also don't remember if it was Forms or the RDBMS)

++ mcs Received on Tue Jun 13 2006 - 10:22:22 CDT