Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!217.73.144.44.MISMATCH!ecngs!feeder.ecngs.de!feeder.news-service.com!de-l.enfer-du-nord.net!feeder2.enfer-du-nord.net!usenet-fr.net!proxad.net!feeder1-2.proxad.net!cleanfeed1-a.proxad.net!nnrp3-2.free.fr!not-for-mail
From: "Michel Cadot" <micadot{at}altern{dot}org>
Newsgroups: comp.databases.oracle.misc
References: <8d654aa9-0b35-4f6d-a4db-a913c2cfa35f@17g2000prr.googlegroups.com>
Subject: Re: Help with TYPE syntax
Date: Thu, 23 Jun 2011 17:49:27 +0200
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6109
Lines: 34
Message-ID: <4e036082$0$7291$426a74cc@news.free.fr>
Organization: Guest of ProXad - France
NNTP-Posting-Date: 23 Jun 2011 17:49:22 MEST
NNTP-Posting-Host: 82.67.171.166
X-Trace: 1308844162 news-3.free.fr 7291 82.67.171.166:2368
X-Complaints-To: abuse@proxad.net
Xref:  news.cambrium.nl


"The Magnet" <art@unsu.com> a écrit dans le message de news: 8d654aa9-0b35-4f6d-a4db-a913c2cfa35f@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