Re: problem: set autotrace on

In article <87uuf0$dvn$1_at_newsg3.svr.pol.co.uk>,   "Paul" <paul_at_tiggerbounce.freeserve.co.uk> wrote:
> Thanks in advance:
>
> Set Autotrace on in SQL*Plus 8.0.5 causes Windows NT to 'Dr Watson'
>
> Scenario:
>
> Oracle Server - 8.0.4.4.1 on IBM OS/390 (MVS)
>
> Client Machine - Windows NT 4, Service Pack 3
>
> SQL*Plus 8.0.5.0.0 with Windows NT Oracle client Patch 8.0.5.2.2
> (Client installed - 8.0.5 with patch applied
> also tried with 8.0.4 Client and 8.0.5 'over the top' and then the
patch)
>
> Issuing the command SET AUTOTRACE ON causes a Dr Watson in PLUS80W.EXE
> (Execution access violation (0xc0000005), address 0x00404dcb.
>
> Using explain plan set statement_id = 'X' for .....; works fine.
>
> This version of the client is required to solve problem of selecting
dates
> brining back control characters (like bug number 747212). The patch
fixes
> this part, but autotrace fails and selecting raw fields also brings
back
> control characters.
>
> Any ideas, solutions etc will be greatly appreciated.
>
> Thanks,
> Paul James
> Data Warehouse Analyst / Programmer (amongst others).
>
>

paul, there is a similar posting a couple days ago. here is the answer by thomas kytes

>Hello out there,

 >
 >it seems that autotrace in SQL*Plus does not work for externally
 >identified users.
 >When I connect with 'sqlplus /' and then issue
 >
 >set autotrace on
 >
 >I get
 >
 >SP2-0619: Fehler bei DB-Anmeldung
 >SP2-0611: Fehler beim Initialisieren von STATISTICS - Bericht
 >
 >The system is Oracle 8.1.5.0.1 on Linux.
 >
 >Any Ideas?
 >
 >Lothar

 that is correct -- its a bug fixed in 8.1.6. You can get the explain plan but not the v$ stats.

 It also won't work if you change your password in a session BEFORE you issue set autotrace (also fi

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Feb 11 2000 - 08:47:50 CST