Link to home
Start Free TrialLog in
Avatar of gram77
gram77Flag for India

asked on

What is the difference between ORA and PLS errors?

Example:
l.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'CM_PROCESS_ATP_CFM_DLM' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ASKER CERTIFIED SOLUTION
Avatar of Sujith
Sujith
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
The PLS error tells you the exact syntax/pl sql related issue in your code.
ORA-06550 - is a generic oracle error raised on pl/sql compilation errors. It will give you the line number in your code where the pls erros has occured.

See this link:
http://www.dba-oracle.com/t_ora_06550.htm