Hello all,
Your help is greatly appreciated ..Iam trying to insert into a table with execute immediate as below ,but ending up with the error..can anyone correct me here please.
EXECUTE IMMEDIATE 'INSERT INTO BATCH_STATEMENT (QUEUE_ID, TABLE_ID, STATEMENT, QUEUE_SEQUENCE_ID) '||'SELECT '||numQUEUE_ID||' ,96, ' ||varSTMT||',1 FROM DUAL';
ORA-06550: line 1, column 17:
PLS-00103: Encountered the symbol "INSERT INTO PROD.BATCH_STATEMENT VALUES '(" when expecting one of the following:
:= . ( @ % ;