Delete statements running with EXECUTE IMMEDIATE command giving ORA-00933: SQL command not properly
using EXECUTE IMMEDIATE command. The problem is that it gives error after executing some statements.
First six statements are executed fine and then gave 'ORA-00933: SQL command not properly ended' while
executing seventh statement.
--Below is how the code looks like:-
----------------------------------------
DECLARE
TYPE r_cursor IS REF CURSOR;
c_delete_cur r_cursor;
v_sql_stmt CLOB;
v_delete_stmt CLOB;
BEGIN
v_sql_stmt :=
ncr_xx_pkg.getdeletescript ('NCR_MFS_SFW_TASKS_D',
'NCR_MFS_SFW_TASKS_E'