Re: Help with TYPE syntax

"The Magnet" <art_at_unsu.com> a écrit dans le message de news: 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'
|
|

The element of estimate_date_tab are not date value but estimate_date_type object.

Regards
Michel Received on Thu Jun 23 2011 - 10:49:27 CDT