Re: dbms_system - set a string parameter in another session?
Date: Mon, 1 Mar 2010 06:40:43 -0800
On Mon, Mar 1, 2010 at 1:21 AM, Dunbar, Norman < norman.dunbar_at_environment-agency.gov.uk> wrote:
> Morning all,
> >> 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.
> I disagree!
> However in my defence, I claim ignorance of how Oracle does things
> internally, but I'm almost 100% certain plain C is used, so, to change a
> string parameter would be as [simple as] follows:
Thank you Norman, I to am of the opinion it could be done.
Perhaps it has never been done because it has not been formally requested?Received on Mon Mar 01 2010 - 08:40:43 CST