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