Hello,
We recently moved to Oracle 11g and I am using Toad 10. I am currently working on a procedure which seemed to work fine before but have recently
started hanging, not sure if it's something related to the environment or it could be that the same issues were coming up earlier but we never noticed them.
To figure out the issue, this is what I am doing:
I compile the procedure in debug mode in Toad, set the break-point at the very top of the procedure,
then start tracing the code, surprisingly, the control moves very fast through the entire code, never hanging anywhere and finally when it reaches the following 'end' statement of the procedure,
it gets stuck there for about a minute or so -
procedure ...
end; --Control gets stuck here at the very end and then after sometime comes back with the results
/
There are no errors or exception thrown, can someone please tell me, how to know what's causing it to get stuck there ?.
Thanks,