All geek questions in one place

Difference between COMPILE and COMPILE WITH DEBUG in Oracle Sql Dev?

I'm new to Oracle SQL, and I was just curious about the differences between the COMPILE and COMPILE WITH DEBUG options. Does this mean if the program unit is just COMPILED, then I can’t debug it?

How about in a production environment where I want to execute a procedure (in debug mode), but without recompiling (to avoid invalidating other objects)?

+3
source share
1 answer

Does this mean if the program unit is just COMPILED, then I can’t debug it?

You're right.

How about in a production environment where I want to execute a procedure (in debug mode), but without recompiling (to avoid invalidating other objects)?

Without recompiling the procedure for debugging, debugging is impossible!

+2
source

Source: https://habr.com/ru/post/1784045/

More articles:


All Articles