Re: Alter session in a package

From: Jan Korecki <Jan.Korecki_at_contactor.se>
Date: Tue, 18 Nov 2003 17:26:57 +0100
Message-ID: <3fba4884$0$97835$57c3e1d3@news3.bahnhof.se>

Hello!

It's easy from oracle version 8.1.7 and onwards: "execeute immediate"

example:

execute immediate('ALTER SESSION SET NLS_DATE_FORMAT=''YYYY-MM-DD HH24:MI:SS''; ');

Regards,
Janne!

was wrote:

> Hi All,
>
> I would like to know how can i make an alter session (for the date
> format) in a PL/Sql function .
>
> Thanks for your help.
Received on Tue Nov 18 2003 - 10:26:57 CST

This message: [ Message body ]
Next message: Rene Nyffenegger: "Re: Alter session in a package"
Previous message: was: "Alter session in a package"
In reply to: was: "Alter session in a package"
Next in thread: Rene Nyffenegger: "Re: Alter session in a package"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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