I have written a procudure where I want to use the truncate table command, in order to permanently delete records from a table; using SQL*PLUS the command executes well but inside the procedure oracle does not even compile and flags the following error: Line # = 16 Column # = 14 Error Text = PLS-00103: Encountered the Symbol "TABLE" when expecting one of the following: := . ( @ % ;
NB.
the truncate command is:
truncate table DESTINATION2
NB.
the truncate command is:
truncate table DESTINATION2