Useful shortcuts for vi editor

Showing posts with label PLS-00201. Show all posts
Showing posts with label PLS-00201. Show all posts

Wednesday, 23 November 2016

PLS-00201 Solution

Error
PLS-00201: identifier 'TABLE_ALPER' must be declared

Solution
Define public synonym for identifier
e.g.
SQL>
CREATE PUBLIC SYNONYM TABLE_ALPER
FOR HR.TABLE_ALPER;