Re: Toad issue ?
From: Bill Ferguson <wbfergus_at_gmail.com>
Date: Mon, 4 Jan 2010 12:49:37 -0700
Message-ID: <4025610e1001041149ye0db733xe38a559ddef752a8_at_mail.gmail.com>
Lee,
Date: Mon, 4 Jan 2010 12:49:37 -0700
Message-ID: <4025610e1001041149ye0db733xe38a559ddef752a8_at_mail.gmail.com>
Lee,
I just ran the script without any problems. I'm running TOAD 10.0.0.41 and Oracle 11.1.0.7 on Windows Server 2003.
Have your client try running it in both SQL*Plus and again in TOAD. Occasionally I get some strange issues, but closing TOAD (and sometimes just doing a "Test Connections") clears any 'memory' problem. Probably something flaky with the memory contents on the clients machine or within the SQL Net client.
-- -- Bill Ferguson On Mon, Jan 4, 2010 at 9:19 AM, Robertson Lee - lerobe <Lee.Robertson_at_acxiom.com> wrote:Received on Mon Jan 04 2010 - 13:49:37 CST
> Guys,
>
>
> AIX 6.1
> Oracle 10.2.0.3
>
> One of our clients is getting an issue when running some scripts. This has
> worked plenty of times before with no errors, the only difference they think
> is that they are running it in TOAD rather than SQL Plus so this could be
> one possible cause?
>
>
>
> select sid from V$SESSION where audsid = (select USERENV('SESSIONID') from
> dual)
>
-- http://www.freelists.org/webpage/oracle-l