Re: PL/SQL Nested Table inside a SQL statement

Mirko wrote:

>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
>
>

You need to use the correct syntax for the nested table. This will 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/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)