how to debugg a procedure or package using
dbms_output.put_line in plsql

Answer Posted / bunty

dbms_output.put_line can be used in Packages, Procedures or
triggers to display message or variable values which can be
used as debugging tool.

Cheers,
Bunty

Is This Answer Correct ?    12 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I run a sql script?

510


How do sql triggers work?

550


What does subquery mean in sql?

536


What are instead of triggers?

621


What are two statement types in sql?

536






how to use regular expression in pattern match conditions? : Sql dba

522


Are stored procedures faster than queries?

522


What is trigger with example?

562


what is not null constraint? : Sql dba

545


what are rollup and cube in t-sql? : Transact sql

657


What is the use of index in hive?

548


In what condition is it good to disable a trigger?

552


Is pl sql still used?

507


How do I partition a table in sql?

538


What is the difference between joins?

534