PL/SQL - Debug PL SQL

GeekInterview.com > Interview Questions > Oracle > PL/SQL

Go To First | Previous Question | Next Question

PL/SQL | Question 220 of 235

Debug PL SQL

How can we generate debugging output from PL/SQL?

Total Answers and Comments: 3

Last Update: June 28, 2008 Asked by: ramyaselvi16

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

June 22, 2008 03:40:39

stshekhar

Member Since: June 2008 Contribution: 5

RE: Debug PL SQL

use the oracle supplied package DBMS_OUTPUT with procedures PUT, PUT_LINE, NEW_LINE etc...

Is this answer useful? Yes | No

June 23, 2008 06:20:14

lokeshRao

Member Since: June 2008 Contribution: 3

RE: Debug PL SQL

Any given table can have a maximum of only one LONG type column

Is this answer useful? Yes | No

June 28, 2008 14:34:59

KD09714

Member Since: June 2008 Contribution: 11

RE: Debug PL SQL

stshekhar is right,

oracle supplied package DBMS_OUTPUT with procedures PUT, PUT_LINE, NEW_LINE etc in case of debugging pl/sql

Is this answer useful? Yes | No