Search code examples
sqloracleplsqloracle-sqldeveloper

Execute immediate with variable throwing error ORA-00936: missing expression

Getting missing expression error when my procedure reaches this statement. ORA-00936: missing expression What is wrong with this statement?

  EXECUTE IMMEDIATE 'SELECT /*+ parallel (8) */ COUNT(1)
  INTO '||v_datacount_backuptable||
  ' FROM cs_transassignment_26weeks';
Solution

  • Should be 

    EXECUTE IMMEDIATE 'SELECT /*+ parallel (8) */ COUNT(1) FROM cs_transassignment_26weeks'
  INTO v_datacount_backuptable;

    i.e. INTO is outside of the statement being executed.