I believe the above will work fine if the block contains some straight forward statements inside the procedure. But if the procedure contains some very complex logic inlcuding writing dynamic queries, it will be hard to proceed in the above said way....

I believe the above will work fine if the block contains some straight forward statements inside the procedure. But if the procedure contains some very complex logic inlcuding writing dynamic queries, it will be hard to proceed in the above said way....