Hello,
This is my first post on wordpress. I want to tell you about how to do debugging stuff on pl/sql developer at Oracle database.
Firstly, a database is needed to be connected. To do this, we have to add tns file at our C:\DevSuite10g\NETWORK\ADMIN\tnsnames.ora location. After making sure the tns file is correctly placed there, we can start working on pl/sql developer.
Open pl/sql developer program, select the database to connect, write your user id and password then click connect.
congratulations! You have successfully connected to database. You have two ways to open debug window. But i will tell you one. Click on the new button(with sheet picture at bottom of page), it shows a menu then select test window. Write down your code there then click start debuggin button. Program will work line by line. then you can implement your classical style debugging there.
The main diffrence between debugging on normal programming languages and pl/sql is that, at pl/sql you have to make sure what all the select statements returns. Because of this reason while debugging, get all the sql statement’s and its subqueries’ return values and calculate them correctly.
Don’t forget, the biggest mistakes at pl/sql programs are made by mistaken select statements.
