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

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!

David BassAsked: 2017-03-31

Who is Participating?

Experts Exchange Solution brought to you by

Enjoy your complimentary solution view.

Get this solution by purchasing an Individual license! Start your 7-day free trial.

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LVL 13

aranaCommented: 2017-03-31

you can use pl/sql debugger, you can get it free from oracle

also you can use dbms_output.put_line and utl_file.put_line to check (output) variable values

also if you are using pl/sql to test it you can add this to your sript

spool output.txt
set serveroutput on

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial

LVL 75

Qlemo"Batchelor", Developer and EE Topic AdvisorCommented: 2017-04-01

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 ...