how to extract compiled stored procedure without line break for long statement
After I compiled stored procedure which contains long statement, the statement would cut into 2 rows into dba_source.
However, when I extract the codes from dba_source table, the source couldn't be compiled successfully because of
the broken lines.
For example, the following statement would be broken into 2 rows like this:
(line 1) gv_Message := 'Interface Description: Interface with Training '|| 'and Development Intran
(line 2) et (Evaluation Statistic Details)';