Re: dbms_system - set a string parameter in another session?
- From: Yong Huang <yong321@xxxxxxxxx>
- To: hkchital@xxxxxxxxxxxxxx
- Date: Mon, 1 Mar 2010 09:47:52 -0800 (PST)
Well, Oracle could have given the option as long as the new string is not longer than the old one. If it is, throw an ORA-xxx error. Yong Huang ----- Original message ----- That string parameters can have "variable width." is actually, in my opinion, a strong enough reason for Oracle to not provide or not even attempt to provide a SET command for parameters in other sessions. At 05:22 AM Saturday, Tanel Poder wrote: >I think one potential technical problem here is that string >parameters can have variable width. > >-- >Tanel Poder ><http://tech.e2sn.com>http://tech.e2sn.com >http://blog.tanelpoder.com > Hemant K Chitale -- http://www.freelists.org/webpage/oracle-l
Other related posts:
- » dbms_system - set a string parameter in another session? - Jared Still
- » RE: dbms_system - set a string parameter in another session? - Bobak, Mark
- » Re: dbms_system - set a string parameter in another session? - Tanel Poder
- » Re: dbms_system - set a string parameter in another session? - Hemant K Chitale
- » RE: dbms_system - set a string parameter in another session? - Dunbar, Norman
- » Re: dbms_system - set a string parameter in another session? - Jared Still
- » RE: dbms_system - set a string parameter in another session? - Bobak, Mark
- » Re: dbms_system - set a string parameter in another session? - Tanel Poder
- » Re: dbms_system - set a string parameter in another session? - Jared Still
- » Re: dbms_system - set a string parameter in another session? - Yong Huang
- » Re: dbms_system - set a string parameter in another session? - Jared Still
- » Re: dbms_system - set a string parameter in another session? - Dennis Yurichev