Help with TYPE syntax

From: The Magnet <art_at_unsu.com>
Date: Thu, 23 Jun 2011 08:04:33 -0700 (PDT)
Message-ID: <8d654aa9-0b35-4f6d-a4db-a913c2cfa35f_at_17g2000prr.googlegroups.com>



I'm sure this is a syntactical issue, but I'm still searching the web:

CREATE OR REPLACE TYPE estimate_date_type AS OBJECT (

 qr1_end_date    DATE,
 qr2_end_date    DATE,
 fr1_end_date    DATE,
 fr2_end_date    DATE);

/
CREATE OR REPLACE TYPE estimate_date_tab AS TABLE OF estimate_date_type;
/

DECLARE
  v_dates_tab estimate_date_tab := estimate_date_tab();

BEGIN
  v_dates_tab := estimate_date_tab(SYSDATE, SYSDATE, SYSDATE, SYSDATE);
.
.
.

PLS-00306: wrong number or types of arguments in call to 'ESTIMATE_DATE_TAB' Received on Thu Jun 23 2011 - 10:04:33 CDT

Original text of this message