Home » SQL & PL/SQL » SQL & PL/SQL » RAISE_APPLICATION_ERROR to display multiple line (11g)
RAISE_APPLICATION_ERROR to display multiple line [message #652493] Fri, 10 June 2016 05:57 Go to next message
harshadsp
Messages: 100
Registered: August 2008
Senior Member

Hello,
Is it possible that RAISE_APPLICATION_ERROR would display the multiple lines of error messages which are stored in plsql table of records?
I have populated the pl/sql table with 3 error messages like:-
Er1
Er2
Er3
when I loop through this table with dbms output I can see all the 3 lines but I am passing the variable of that table type in RAISE_APPLICATION_ERROR its showing the last line of the table, obviously.

How I could show all the 3 messages in just one RAISE_APPLICATION_ERROR?

Thanks
Re: RAISE_APPLICATION_ERROR to display multiple line [message #652494 is a reply to message #652493] Fri, 10 June 2016 08:35 Go to previous message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
You have a total of 2000 characters that can be put out by the RAISE_APPLICATION_ERROR. Make a variable containing all three line separated by a CHR(10). Then call the RAISE_APPLICATION_ERROR and specify the variable name.
Previous Topic: Oracle Special character while dbms_output
Next Topic: Query Date Ranges with select statement (merged 3)
Goto Forum:
  


Current Time: Sun Aug 01 19:27:47 CDT 2021