Binding DATEs in Forms 4.0

   I think I've run across my first serious bug in Forms 4:

   Whenever I try to bind an item of type DATE in an SQL statement within a trigger it blows up at run time. The complaint is that the bind variable is of the wrong size for type DATE. Eg.:

   SELECT COUNT(*)

      INTO :myblock.a_number_item
      FROM my_table
      WHERE some_date_column = :myblock.a_date_item;
                               ^^^^^^^^^^^^^^^^^^^^

   Binding NUMBERs and CHARs are fine, but binding a DATETIME
also causes the problem.        

   Has anyone else run across this? I'm running Forms 4.0.11 against Oracle 7.0.12.

-- 
   - Doug Harris
     Database Administrator,
     System Development Division,
     Statistics Canada             ### Standard Disclaimer Applies ###