ken quirici wrote:
> Hi,
>
> Another interval problem?
>
> sql>@interval_test
>
> *where interval_test.sql is:
>
>
> *set serveroutput on size 1000000
>
> *declare
> * interval2 interval day(1) to second(3);
>
> *begin
> * interval2 := interval '11:20' hour to minute;
> * dbms_output.put_line('interval2: ' || interval2);
> *end;
> */
>
> *set serveroutput off
>
> declare
> *
> ERROR at line 1:
> ORA-06550: line 5, column 15:
> PLS-00167: keyword BULK is used in a wrong context
>
> sql> l
>
> 1 declare
> 2 interval2 interval day(1) to second(3);
> 3
> 4 begin
> 5 interval2 := interval '11:20' hour to minute;
> 6 dbms_output.put_line('interval2: ' || interval2);
> 7* end;
> QL>
>
> I hope that's clear. The question is, is this an Oracle bug or is there something
> wrong with the syntax of my interval literal? It seems to match the examples in
> the 9i documentation.
>
> Thanks.
>
> Ken Quirici
Try not to use Intervals. I did and they just caused me pain and you can
make do without them! Intuitively they do sometimes seem the right thing
to use so it is ashame really. I think they are new in Oracle 9i so
perhaps they are better in Oracle 10g???
Received on Thu Oct 28 2004 - 01:04:19 CDT
