Hello,
I've quite large SQL script (~11MB) which creates database objects (tables, procedures, functions)
Because script is automatically generated all procedures and function in script are created in alphabetalical order. That's why during script execution I have a lot compiler errors which is totally ok, since at the end of the script I compile all database objects.
Problem is that creation of each procedure/function in SQLDeveloper takes around 5-10 second for each procedure. I think problem is related to fact that SQLDeveloper shows me details of compilation error which I don't need at these time.
Function DPsp_EvalSl compiled
LINE/COL ERROR
----------------------------------------------
21/15 PL/SQL: ORA-00904: "DPsp_Val": invalid identifier
23/17 PL/SQL: ORA-00904: "DPsp_WalSopA": invalid identifier
Errors: check compiler log.
Is there any option in SQLDeveloper to turn off detailed compiler log and speed up execution process a little ?
Regards