<div>
<div class="content wysiwyg-content">
HI,<br />
Has anybody ever used sql trace for debugging?<br />
For example if I run a PL/SQL block and get a &quot;no data found&quot; error then<br />
can I run the same pl/sql block with trace on this time to find which statement<br />
the error is occuring at?<br />
Thanks in advance.
</div>
</div>


HI,
Has anybody ever used sql trace for debugging?
For example if I run a PL/SQL block and get a "no data found" error then
can I run the same pl/sql block with trace on this time to find which statement
the error is occuring at?
Thanks in advance.

sql trace for debugging?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.