OraFAQ Forum: Client Tools » Enable Trace in TOAD ??

Home » Other » Client Tools » Enable Trace in TOAD ??

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Enable Trace in TOAD ?? [message #208077]

Fri, 08 December 2006 01:40

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?

Report message to a moderator

Re: Enable Trace in TOAD ?? [message #208147 is a reply to message #208077]

Fri, 08 December 2006 05:54

ThomasG
Messages: 3212
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;

Report message to a moderator

Previous Topic:	how to enter isqlplus environment on standalone pc
Next Topic:	TOAD - SQL Formatting Options

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 20:10:11 CST 2024