setting session parameter
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: setting session parameter

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    setting session parameter

    Is it possible to set session modifiable init.ora prameter to a different session ?

    Say i (BLAKE) want to enable nls_language=american for SCOTT'S session.
    Last edited by bang_dba; 09-20-2005 at 02:38 PM.
    ------------------------------------------------------------------------
    The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway

  2. #2
    Join Date
    Sep 2002
    Posts
    376
    Looks like there is no option in oracle to do this.
    ------------------------------------------------------------------------
    The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Oh yes, there is. It's available through DBMS_SYSTEM package, which is undocumented, so you are using it on your own risk! There are two procedures there: SET_INT_PARAM_IN_SESSION and SET_BOOL_PARAM_IN_SESSION. You can search the web for how to use them....
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width