6 Replies Latest reply on Jan 26, 2011 6:00 AM by louo

    'PLS-00103: Encountered the symbol "end-of-file" when expecting one' Error

    user10916886
      Hi,

      While executing the following -

      BEGIN
      EXECUTE IMMEDIATE 'INSERT INTO TAB1 (Field1,field2,field3) SELECT Field1,field2,field3 FROM tab2 partition(P_200711);' ;
      END;

      I get the following error.

      ORA-06550: line 3, column 4:
      PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

      ; <an identifier> <a double-quoted delimited-identifier>
      The symbol ";" was substituted for "end-of-file" to continue.


      When I run the same query on toad it runs fine.

      Thanks,
      Vishal Gupta