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



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

Answer / 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

More SQL PLSQL Interview Questions

how to concatenate two character strings? : Sql dba

0 Answers  


I have a CURSOR then why we need BULK COLLECT again?

1 Answers  


How do you explain an index?

0 Answers  


What is native sql query?

0 Answers  


What does := mean in pl sql?

0 Answers  






What is view? Can we update view

0 Answers  


what is purge command explain about oracle performance tuning

2 Answers   Accenture, eCentric Solutions,


what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

0 Answers  


What is the example of procedure?

0 Answers  


What is the full form of sql?

0 Answers  


Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers   Wipro,


Is left join faster than inner join?

0 Answers  


Categories