Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About suhaasv

  • Rank
  1. I have a stored procedure where is an Execute Immediate will call a "Begin ... End " block which contains another Execute Immediate which will be called only if a certain condition is met. The inner Execute Immediate command inside "Begin... End clock" is enclosed in single quotes. So it looks like BEGIN ...SOME STUFF HERE... FOR ..... LOOP EXECUTE IMMEDIATE 'BEGIN IF (condition) THEN EXECUTE IMMEDIATE 'DML STRING' END IF END;' END LOOP; END; That begs another question can an Execute Immediate statement be called from within the loop. I think the answer is yes.