Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

line continuation character for strings?

chuckersDec 3 2009 — edited Dec 3 2009
In compiled code, is there a line continuation character for strings? I know that I could create a variable and concatenate it to itself with additional text on each line, but is there something like the following available:
create or replace procedure throw_long_error
as
begin
  raise_application_error (-20500, 'You made the mistake of running this procedure and now you have to deal with
                                     a really, really, really, really long error message which informs you of the
                                     unfortunate circumstances within which you now reside.');
end throw_long_error;
While the above code compiles & runs, you get line breaks in the error output. I'd rather it just come out as a string without those Chr(10) || Chr(13) silently embedded into it.
BEGIN throw_long_error; END;
Error at line 1
ORA-20500: You made the mistake of running this procedure and now you have to deal with
                                     a really, really, really, really long error message which informs you of the
                                     unfortunate circumstances within which you now reside.
ORA-06512: at "FORBESC.THROW_LONG_ERROR", line 4
ORA-06512: at line 1
--=cf
This post has been answered by victorp on Dec 3 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 31 2009
Added on Dec 3 2009
3 comments
981 views