Home » SQL & PL/SQL » Client Tools » Enable Trace in TOAD ??
Enable Trace in TOAD ?? [message #208077] Fri, 08 December 2006 01:40 Go to next message
rak007
Messages: 107
Registered: October 2006
Location: Mumbai / Pune, India
Senior Member
I am running an anonymous block in TOAD and would like to enable the trace for the same. Is it possible in TOAD to enable the same before/while running the anonymous block? If yes then how?
Re: Enable Trace in TOAD ?? [message #208147 is a reply to message #208077] Fri, 08 December 2006 05:54 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Just with a normal alter session?

This here works in SQLTools, it should in TOAD :

ALTER SESSION SET sql_trace=TRUE;

DECLARE
BEGIN
   Dbms_Output.put_line('Boo');
END;
/

ALTER SESSION SET sql_trace=FALSE;
Previous Topic: how to enter isqlplus environment on standalone pc
Next Topic: TOAD - SQL Formatting Options
Goto Forum:
  


Current Time: Mon Dec 05 10:44:56 CST 2016

Total time taken to generate the page: 0.08042 seconds