1.
create or replace procedure test_prc(p_data_dt in date) IS
e_name emp.ename%type;
begin
select ename into e_name
from emp where hiredate =p_data_dt;
DBMS_OUTPUT.PUT_LINE(e_name || '---' ||p_data_dt);
end;
此时输入的是日期型的参数:
SQL> call test_prc(date'1980-12-17');
SMITH---17-DEC-80
Call completed.
---------------------------------------------------------------------
2.
create or replace procedure test_prc(p_data_dt in VARCHAR) IS
e_name emp.ename%type;
v_data_dt DATE :=to_date(p_data_dt,'YYYY-MM-DD');
begin
select ename int