When PL/SQL developer is used to develop oracle stored procedures, a very confusing problem is that the stored procedures can be compiled after compilation, that is, there are errors after compilation, there is a small Red Cross in the name of the stored procedure file. To solve this problem, the following methods are provided for reference;
Use the troubleshooting function provided by the tool. Step: Expand Procedures in the left navigation bar, right-click the file with a Red Cross, and then click "re-compile reference object ", A dialog box will pop up, with two buttons at the top, one being gear and the other being refresh. First, click the refresh arrow to find the current stored procedure. Then, click the gear and re-compile. The compilation result is displayed at the bottom. If your stored procedure has problems, take a closer look at the following error message, and you may be able to solve the problem soon.
Jfance BLOG