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 (DOT) it

Mirko wrote:

require a constructor of which you can read
all about them at http://tahiti.oracle.com and find numerous examples at
http://asktom.oracle.com.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

On 9 Oct 2003 10:01:54 -0700, mirkocarlini (AT) yahoo (DOT) co.uk (Mirko) wrote:

AFAIK You can only use select ... table(A_Collection) operations if
A_Collection is defined explicitly for the data dictionary. Types
defined locally in procedure or packages are not.

All you have to do is use : create type A_Collection as table of .....

Phenton.