Re: dbms_system - set a string parameter in another session?
- From: Jared Still <jkstill@xxxxxxxxx>
- To: norman.dunbar@xxxxxxxxxxxxxxxxxxxxxxxxx
- Date: Mon, 1 Mar 2010 06:40:43 -0800
On Mon, Mar 1, 2010 at 1:21 AM, Dunbar, Norman <
norman.dunbar@xxxxxxxxxxxxxxxxxxxxxxxxx> 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
Other related posts:
