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 |
What is nvarchar max in sql?
what is a stored procedure? : Sql dba
How much does sql certification cost?
How does a trigger work?
What is rownum in sql?
What are the sql commands?
How can I speed up sql query?
What is the basic difference between a sql and stored procedure ?
What do you mean by query optimization?
What version is sql?
a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.
what is sql? : Sql dba
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)