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


      
--
//www.freelists.org/webpage/oracle-l


Other related posts: