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 relationship? How many types of relationship are there?
What is Overloading of procedures ?
Can we write create command in the plsql block?if possible how?
What is sql mysql pl sql oracle?
What is sqlite used for?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
Can you inner join the same table?
When do we use triggers?
I want to know last five transactions or records from emp table, from now?
What is a temp table?
What are stored procedures in mysql?
There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?
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)