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

From: Yong Huang <>
Date: Mon, 1 Mar 2010 09:47:52 -0800 (PST)
Message-ID: <>

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

Hemant K Chitale       

Received on Mon Mar 01 2010 - 11:47:52 CST

Original text of this message