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 |
Explain the difference in execution of triggers and stored procedures?
Is sql port 1433 encrypted?
What are code pages ?
Define a temp table?
how to delete an existing column in a table? : Sql dba
how to enter characters as hex numbers? : Sql dba
How do I run a sql query in pgadmin 4?
how to analyze tables with 'mysqlcheck'? : Sql dba
How do I kill a query in postgresql?
what are the differences between binary and varbinary? : Sql dba
How to Declare Fixed Length String Value In PL SQL
Describe different types of general function used in sql?
Oracle (3253)
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)