PL/SQL - Debug PL SQL

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

Go To First | Previous Question | Next Question

PL/SQL | Question 220 of 241

Debug PL SQL

How can we generate debugging output from PL/SQL?

Total Answers and Comments: 4

Last Update: February 24, 2009 Asked by: ramyaselvi16

Sponsored Links

Best Rated Answer

—

Submitted by: stshekhar

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

Above answer was rated as good by the following members:
go2lightspeed

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

1 0

Overall Rating: +1

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

0 1

Overall Rating: -1

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

February 24, 2009 06:13:40

kperumal75

Member Since: September 2008 Contribution: 2

RE: Debug PL SQL

Use "SHOW ERRORS" command.

Regards
Karthik

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank