PL/SQL Nested Table inside a SQL statement

Hi,
I have a PL/SQL procedure (inside a package) with the following SQL code:

  INSERT INTO set_day_substore_r_k

            (day_id, ...)
  SELECT e.day_id,...
  FROM
  e,
  TABLE(datetimes_required) dtr,

• only find the capture_dates within the range of the datetimes we require e.capture_date >= dtr.dt AND e.capture_date < (dtr.dt + reporting_common.day_interval)

ORA-22905: cannot access rows from a non-nested table item
ORA-06512: at "M.PACKAGENAME", line 842
ORA-06512: at line 1

Line 842 is the BEGIN of the procedure.

Any ideas?
THANK YOU,
Mirko PLEASE REPLY TO: mirko.carlini_at_libero.it Received on Thu Oct 09 2003 - 12:01:54 CDT