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 -- //www.freelists.org/webpage/oracle-l