Re: executing PL/SQL procedure

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_at_mail.com> wrote in message news:a677a6a3.0206060604.4b668efd_at_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
Received on Thu Jun 06 2002 - 16:11:47 CEST