Re: Help with TYPE syntax

From: ddf <oratune_at_msn.com>
Date: Thu, 23 Jun 2011 08:57:48 -0700 (PDT)
Message-ID: <3ad86414-c625-4118-8a11-5bbaa141f986_at_k27g2000yqn.googlegroups.com>

On Jun 23, 8:04 am, The Magnet <a..._at_unsu.com> wrote:
> 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'
SQL> CREATE OR REPLACE TYPE estimate_date_type AS OBJECT (

  2   qr1_end_date    DATE,
  3   qr2_end_date    DATE,
  4   fr1_end_date    DATE,
  5   fr2_end_date    DATE);

  6 /

Type created.

SQL> CREATE OR REPLACE TYPE estimate_date_tab AS TABLE OF   2 estimate_date_type;
  3 /

Type created.

SQL>
SQL>
SQL> DECLARE
  2    v_dates_tab         estimate_date_tab := estimate_date_tab();

  3
  4
  5 BEGIN
  6 v_dates_tab := estimate_date_tab(estimate_date_type(SYSDATE, SYSDATE, SYSDATE, SYSDATE));
  7 END;
  8 /

PL/SQL procedure successfully completed.

SQL> David Fitzjarrell Received on Thu Jun 23 2011 - 10:57:48 CDT