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

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 1 Mar 2010 06:40:43 -0800
Message-ID: <bf46381003010640k5832f892n1f5c198b823ed9b_at_mail.gmail.com>



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?

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 - 08:40:43 CST

Original text of this message