Dynamic SQL Statement is Anonymous Block or CALL Statement
--============================================== Repeated Placeholder Names in Dynamic SQL Statements --============================================== If you repeat placeholder names in dynamic SQL statements , be aware that the way placeholders are associated with bind variables depends on the kind of dynamic SQL statement. Topics 1 . Dynamic SQL Statement is Not Anonymous Block or CALL Statement 2 . Dynamic SQL Statement is Anonymous Block or CALL Statement --============================================== Dynamic SQL Statement is Anonymous Block or CALL Statement --============================================== If the dynamic SQL statement represents an anonymous PL /SQL block or a CALL Each unique placeholder name must have a corresponding bind variable in the USING clause . If you repeat a placeholder name, you need not repeat its corresp...