This content has been marked as final. Show 1 reply
You posted quite a bit today, so perhaps you have already worked this out. If not...
1. View -> Reports -> Data Dictionary Reports -> All Objects -> Invalid Objects [for a specific schema name]
2. Next, for each invalid stored procedure listed in (1)...
Of course, success in addressing any errors depends on your skill level dealing with Oracle PL/SQL.
a. Open in the code editor from the Connections navigator tree b. Click on the Compile icon (two gears meshed together) in code editor tool bar. c. Look in the Compiler log pane for errors. d. Correct the errors
Also, it may be helpful to read over section *3.2 Stored Procedures* in the supplementary migration guide:
SQL Developer Team