OraFAQ Forum: SQL & PL/SQL » https://community.oracle.com/message/14958599#14958599

Home » SQL & PL/SQL » SQL & PL/SQL » https://community.oracle.com/message/14958599#14958599 (Oracle Database 11g Enterprise Edition Release 11.2.0.4.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

https://community.oracle.com/message/14958599#14958599 [message #672274]

Tue, 09 October 2018 15:58

suhaas
Messages: 5
Registered: June 2015

Junior Member

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.

Report message to a moderator