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