Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error(8,2): PLS-00103: Encountered the symbol "INSERT" when expecting one of the following

waseem_mdSep 7 2020 — edited Sep 8 2020

Hello All,

I have migrated stored procedures from Microsoft Sequel Server to Oracle developer, All of the store procedures gives an error of

  • Error(8,2): PLS-00103: Encountered the symbol "INSERT" when expecting one of the following: * & = - + ; < / > at in is mod remainder not rem return returning  <> or != or ~= >= <= <> and or like like2 like4 likec between into using || multiset bulk member submultiset The symbol ";" was substituted for "INSERT" to continue.

Can anyone please help me how to resolve it.

Thanks

Waseem

Comments
Post Details
Added on Sep 7 2020
6 comments
2,455 views