Re: doing two session-setting ops in one SQL submission...

On Thu, 19 Feb 2004 11:31:51 -0800, Joe Weinstein <joeNOSPAM_at_bea.com> wrote:

>I am naively trying:
>
>"BEGIN alter session set nls_date_format = 'MM/DD/YYYY'; set role xxxx_role identified by xxxx; END;".
>
>This fails*. Is there working syntax for what I want to do?
>Thanks in advance,
>
>Joe Weinstein at BEA

either use the dbms_session package (has procedures for both commands) or use execute immediate.
Note: Pl/sql is only capable of ordinary sql statements directly.

--
Sybrand Bakker, Senior Oracle DBA