Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Alter session in a package

Re: Alter session in a package

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 18 Nov 2003 16:47:53 GMT
Message-ID: <bpdifp$1nqgm4$1@ID-82536.news.uni-berlin.de>

> 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.ch
Received on Tue Nov 18 2003 - 10:47:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US