PL/SQL (MOSC)

MOSC Banner

Delete statements running with EXECUTE IMMEDIATE command giving ORA-00933: SQL command not properly

edited Jan 2, 2014 11:54PM in PL/SQL (MOSC) 7 commentsAnswered
I am executing a pl/sql block where i am fetching delete statements from a cursor and then running them
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'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center