Question: I am running a PL/SQL procedure on my system.
I am getting the following error:
ORA-24344: success with
compilation error
but it is not showing details about the ORA-24344 error. Can you help me out?
Answer: To diagnose any error, you start by using the oerr utility to display the ORA-24344 error:
ORA-24344: success with compilation error
Cause: A sql/plsql compilation error occurred.
Action: Return OCI_SUCCESS_WITH_INFO along with the error code
Simply put, ORA-24344 tells you there is a problem somewhere in your code.
PL/SQL does not always tell you about compilation errors. Instead, it gives you
a cryptic message such as "success with compilation error " or "procedure
created with compilation errors".
Depending on the complexity of your code, you can skim it for
obvious syntax errors. If it's not immediately obvious what is
wrong or missing, issue the following command:
show errors procedure
<procedure_name> ;
Alternatively, to see the most recent errors, type the following:
SHOW ERRORS
or the abbreviated version works just as well:
SHO ERR
The location of the error given as part of the error message is not
always accurate, but it is generally the best place to start your
investigation.