From: jmoni@mail.com (Jake)
Newsgroups: comp.databases.oracle
Subject: executing PL/SQL procedure
Date: 6 Jun 2002 07:04:29 -0700
Organization: http://groups.google.com/
Lines: 23
Message-ID: <a677a6a3.0206060604.4b668efd@posting.google.com>
NNTP-Posting-Host: 207.51.47.2
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1023372270 11510 127.0.0.1 (6 Jun 2002 14:04:30 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 6 Jun 2002 14:04:30 GMT


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