We help IT Professionals succeed at work.

SQL*Plus debugging?  Is there a way to step through the SQL Script?

David Bass
David Bass asked
on
1,051 Views
Last Modified: 2017-04-04
Hi I have a colleague who has a SQL Script that she runs in Crystal Reports.  I need this similar script to run on our AIX box for a certain program.  It runs fine in Crystal, but it just hangs on our IBX AIX box.

It has like 14 SELECT Statements.  Is there a way I can step through this script in SQL, like a debug tool, so I can see why it is running a long time or failing without me knowing?  I wish there was a log file or something?  Is there??

Thanks in advance for help!
Comment
Watch Question

CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Qlemo"Batchelor", Developer and EE Topic Advisor
CERTIFIED EXPERT
Top Expert 2015

Commented:
You can always take each PL/SQL command and post it one after another. There will be no difference then to single-stepping in a debugger, but without any added tools and effort ...

Author

Commented:
Thank you for your help!