From: "Jim Kennedy" <kennedy-family@attbi.com>
Newsgroups: comp.databases.oracle
References: <a677a6a3.0206060604.4b668efd@posting.google.com>
Subject: Re: executing PL/SQL procedure
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <D4KL8.125410$ux5.179660@rwcrnsc51.ops.asp.att.net>
NNTP-Posting-Host: 12.224.242.123
X-Complaints-To: abuse@attbi.com
X-Trace: rwcrnsc51.ops.asp.att.net 1023372707 12.224.242.123 (Thu, 06 Jun 2002 14:11:47 GMT)
NNTP-Posting-Date: Thu, 06 Jun 2002 14:11:47 GMT
Organization: AT&T Broadband
Date: Thu, 06 Jun 2002 14:11:47 GMT


You have an out parameter of date and when you are calling it you don't
specify a variable to put the out parameter into.  Like: (check syntax in
the manual)

variable mydate date;
exec get_date(:mydate);
print mydate
Jim
"Jake" <jmoni@mail.com> wrote in message
news:a677a6a3.0206060604.4b668efd@posting.google.com...
> Hello all,
>
> Could someone tell me why I am having this error executing this procedure?
>
> Create or Replace procedure get_date (today out date) is
> begin
> select sysdate into today from dual;
> end;
> /
>
> SQL> exec get_date;
> BEGIN get_date; END;
>
>       *
> ERROR at line 1:
> ORA-06550: line 1, column 7:
> PLS-00306: wrong number or types of arguments in call to 'GET_DATE'
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
> Thanks,
>
> Jake