EXECUTE IMMEDIATE

How to Resolve ORA-01031: Insufficient Privileges

by Ed Chen
June 24, 2020May 26, 2023
1 Comment

ORA-01031 ORA-01031: Insufficient Privileges means that the current user did not use the right privilege to process the SQL statement. Since this error can be… Read More »

How to Resolve PLS-00103: Encountered the symbol

by Ed Chen
June 14, 2019June 1, 2023

PLS-00103 I cannot cover all error patterns of PL-00103 in this post, here are some cases that encounter PLS-00103. Missing IS Missing END Missing Slash… Read More »

ORA-00904 Invalid Identifier - Oracle Database Object Name Recognition Examples

How to Resolve ORA-00904 Invalid Identifier

by Ed Chen
March 12, 2019April 20, 2023
4 Comments

ORA-00904 ORA-00904 means that you used an invalid identifier to be a column name, which is most likely unmatched in name or incorrect syntax. Since… Read More »

JavaScript is not enabled. Please enable it and reload the page.