Q
Problem solve Get help with specific problems with your technologies, process and projects.

Line placement in an EMESSAGE

Have you ever heard of a way in an EMESSAGE to be able to make the second sentence start on the next line?

Example:

 f_yes_no( 'The OTB for Category '||classRec.class||' has been exceeded. '||
                                '     Available Amount is '||l_avail||' and the amount spent was '||classRec.order_cost||
                                '.      Do you want to continue this order in APPROVED/IN TRANSIT?' )

I want the sentence starting with "Available..." to start on the next line, and the sentence starting with "Do you..." on the following line.

Is there some magic "end-of-line" character or something that you are aware of to accomplish this. I hate to guess and do spaces.... looks like sloppy coding.


Try concatenating a carriage return and line feed to your output string. There is a function to return special character in Oracle called CHR. The ASCII value of Carriage return and line feeds are 10 and 13 respectively. So, concatenating CHR(10) || CHR(13) will do the trick for you.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close