kumar0828 wrote:NO refcursor NO loop. Just build your INSERT INTO ... SELECT .. FROM string and execute it using EXECUTE IMMEDIATE. And it can very well insert multiple rows in one go.
I have handled the exception block.
If i have added that inside the loop it will automatically insert single row ?