Re: Change other users session

From: Tony van Lingen <tony_vanlingen_at_technologyonecorp.com>
Date: Mon, 20 Jul 2009 09:55:55 +1000
Message-ID: <4A63B28B.7050005_at_technologyonecorp.com>

Those handy functions have disappeared in 10gR2 though.. A search through the dba_source table shows that they've not just moved to another package, but dropped completely :(

Cheers,
Tony

Ian Cary wrote:
> Its a shame you want to change a string value because you can change other
> types using
>
> dbms_session.set_bool_param_in_session and
> dbms_session.set_int_param_in_session
>
> Not much help I know, but may be worth knowing in the future.
>
> Cheers,
>
> Ian
>
>
>
> |---------+----------------------------->
> | | Jan-Hendrik.Boll_at_d|
> | | ataport.de |
> | | Sent by: |
> | | oracle-l-bounce_at_fr|
> | | eelists.org |
> | | |
> | | |
> | | 17/07/2009 12:16 |
> | | Please respond to |
> | | Jan-Hendrik.Boll |
> | | |
> |---------+----------------------------->
> >--------------------------------------------------------------------------------------------------------------|
> | |
> | To: oracle-l_at_freelists.org |
> | cc: |
> | Subject: Change other users session |
> >--------------------------------------------------------------------------------------------------------------|
>
>
>
>
> Hi folks,
>
> is there any way to change the parameters of an other users session?
> I want to change the parameter curser_sharing without interrupting the
> other sessions jobs.
> (Some kind of third-party import-tool )
>
> Any input is appreciated.
>
> regards,
> Jan-Hendrik
>
> This email was received from the INTERNET and scanned by the Government
> Secure Intranet anti-virus service supplied by Cable&Wireless in
> partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) In
> case of problems, please call your organisation’s IT Helpdesk.
> Communications via the GSi may be automatically logged, monitored and/or
> recorded for legal purposes.(See attached file: atthdlm0.dat)
>
> For the latest data on the economy and society consult National Statistics at http://www.statistics.gov.uk
>
> *********************************************************************************
>
>
> Please Note: Incoming and outgoing email messages are routinely monitored for compliance with our policy on the use of electronic communications
> *********************************************************************************
>
>
> Legal Disclaimer : Any views expressed by the sender of this message are not necessarily those of the Office for National Statistics
> *********************************************************************************
>
>
> The original of this email was scanned for viruses by the Government Secure Intranet virus scanning service supplied by Cable&Wireless in partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) On leaving the GSi this email was certified virus free.
> Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes.
>

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

Received on Sun Jul 19 2009 - 18:55:55 CDT