create or replace package p_view_date is
function set_date(indate varchar2) return date;
function get_date return date;
end p_view_date;
create or replace package body p_view_date is
indatevalue date;
function set_date(indate varchar2) return date is
begin
select to_date(indate,'YYYY-MM-DD HH24:MI:SS') into indatevalue from dual;
-- indatevalue:=indate;
return indatevalue;
end;
function get_date return date is
begin
return indatevalue;
end;
end p_view_date;
function set_date(indate varchar2) return date;
function get_date return date;
end p_view_date;
create or replace package body p_view_date is
indatevalue date;
function set_date(indate varchar2) return date is
begin
select to_date(indate,'YYYY-MM-DD HH24:MI:SS') into indatevalue from dual;
-- indatevalue:=indate;
return indatevalue;
end;
function get_date return date is
begin
return indatevalue;
end;
end p_view_date;