CODEWITHSUNDEEP
sqloracle-databasedebuggingcompilation
Hiro
Hiro

Reputation: 183

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

I am new to Oracle SQL developer and I was just curious as to the difference between the COMPILE and COMPILE WITH DEBUG options. Does this mean if a program unit is simply COMPILED, then I will not be able to debug it ?

What about in a production environment, where I want to run through the procedure (in debug mode) but without recompiling (in order to avoid invalidating other objects) ?

Upvotes: 4

Views: 9458

Answers (1)

Tim
Tim

Reputation: 2831

Does this mean if a program unit is simply COMPILED, then I will not be able to debug it ?

You're right.

What about in a production environment, where I want to run through the procedure (in debug mode) but without recompiling (in order to avoid invalidating other objects) ?

Without recompiling a procedure for debug, debugging is not possible!

Upvotes: 3

Related Questions