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

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Mon, 1 Mar 2010 10:14:28 -0500
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F3DD85C04_at_AAPQMAILBX02V.proque.st>

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.)

-Mark

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.
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?

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Mar 01 2010 - 09:14:28 CST