RE: dbms_system - set a string parameter in another session?
Date: Mon, 1 Mar 2010 10:14:28 -0500
Of course, the problem with formally requesting it is, how do you file an enhancement request against a package that doesn't exist?
(As of 11gR2, dbms_system isn't documented, with the exception of a sample code block, related to streams, that makes use of dbms_system.ksdwrt.)
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still
Sent: Monday, March 01, 2010 9:41 AM
To: norman.dunbar_at_environment-agency.gov.uk Cc: ORACLE-L
Subject: Re: dbms_system - set a string parameter in another session?
On Mon, Mar 1, 2010 at 1:21 AM, Dunbar, Norman <norman.dunbar_at_environment-agency.gov.uk<mailto: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.
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 - 09:14:28 CST