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_tab AS TABLE OF estimate_date_type;
/
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