Re: dbms_system - set a string parameter in another session?

From: Yong Huang <yong321_at_yahoo.com>
Date: Mon, 1 Mar 2010 09:47:52 -0800 (PST)
Message-ID: <111181.72691.qm_at_web80604.mail.mud.yahoo.com>



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
Received on Mon Mar 01 2010 - 11:47:52 CST

Original text of this message