Another PL/SQL INTERVAL error?

From: ken quirici <kquirici_at_yahoo.com>
Date: 26 Oct 2004 07:16:06 -0700
Message-ID: <eeca902a.0410260616.e00a918@posting.google.com>

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 Received on Tue Oct 26 2004 - 09:16:06 CDT