Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> problem: set autotrace on

problem: set autotrace on

From: Paul <paul_at_tiggerbounce.freeserve.co.uk>
Date: Thu, 10 Feb 2000 18:00:14 -0000
Message-ID: <87uuf0$dvn$1@newsg3.svr.pol.co.uk>


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). Received on Thu Feb 10 2000 - 12:00:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US