0
Dll . NET is used to compile scripts, but in Databases Oracle 10g the scripts are decompiled and it is necessary to compile using a SQL Developer, for example.
Found that this occurs only for Oracle 10g.
- Why does this happen?
- How to fix or advice to find the source of the problem?
What exactly is your problem?
– Leandro Angelo
In sql plus you can do for example ALTER PROCEDURE E<name> COMPILE; sql Developer actually mounts the sql commands and sends them to the database. Never heard of this decompiler.
– Motta
Even using ALTER PROCEDURE <name> COMPILE the script continues to decompile, running via cmd continues to decompile as well. The only time it compiled was when I right-clicked on it and "compile", and it is guaranteed that the script is correct. (This is by the SQL IDE Developer) , by PL/SQL Developer it only compiles when the script is opened and clicked on the button to run. This is a case where it occurs only in Oracle 10g
– Matheus