KriC wrote:Not really. once the code is compiled into the database, it has been compiled to a code that is not exactly like the source code (and if Native compilation is used, then it's definitely nothing like the source code). So when this code actually executes it is executing the compiled version of the code, not the source code itself. This is the difference between compiled code and interpreted code. To step through in a debug fashion this is typically done using an interpreted code, or some very clever techniques employed by some tools. You're certainly not going to achieve step by step debugging in SQL*Plus.
yes , i can
But in production environment , we dont have access of TOAD or any other tool. we can only connect by sqlplus.
So if any method avilable then let me know.