Using TOAD for Oracle DBA Suite.
In Editor mode, I have PL/SQL codes for a VIEW. One of the lines is 900+ characters long. TOAD formats it correctly and beautifully. However, it doesn’t seem to retain the word wrap format when compiled.
The effects: The procedure that uses that views has an error ORA-06512.
On the other hand, if we format and execute the view in SQL Plus, we do not get that error.
So it seems to me, what TOAD has on editor is only visual deep and doesn’t retain the formatting on compilation / save. Is there a setting I can set to keep the formatting when compile / save exactly what I see on editor?