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@xxxxxxxxxx> wrote: > 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) > -- //www.freelists.org/webpage/oracle-l