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

What is the max nvarchar size?

678


How can I see all tables in sql?

727


What is count * in sql?

747


What is the main difference between sql and pl/sql?

756


What is the difference between function and procedure in pl/sql?

746






tell us something about heap tables. : Sql dba

819


How do temporal tables work?

692


How much ram can sql express use?

699


What is self-join and what is the requirement of self-join?

841


How are sql commands classified?

800


What is the primary key?

700


How do you modify a table in sql?

800


explain the difference between myisam static and myisam dynamic. : Sql dba

705


What is trigger and how to use it in sql?

723


What are all the different normalizations?

744