Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Alter session in a package
> I would like to know how can i make an alter session (for the date
> format) in a PL/Sql function .
create or replace package util as
procedure common_date;
end;
/
create or replace package body util as
procedure common_date is
begin
execute immediate
'alter session set nls_date_format = ''dd/mon/yyyy''';
end common_date;
end util;
/
exec util.common_date
hth
Rene
-- Rene Nyffenegger http://www.adp-gmbh.chReceived on Tue Nov 18 2003 - 10:47:53 CST