Home » Developer & Programmer » Reports & Discoverer » System.message_level Equivalent in Reports
System.message_level Equivalent in Reports [message #260307] Sat, 18 August 2007 05:13 Go to next message
raniahalga
Messages: 6
Registered: August 2007
Junior Member

Hi friends,

What's the equivalent to system.message_level in oracle reports.

Regards,
Rania
Re: System.message_level Equivalent in Reports [message #260410 is a reply to message #260307] Sun, 19 August 2007 10:54 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
There's none, as far as I can tell.

What do you plan to do with it, anyway?
icon4.gif  Re: System.message_level Equivalent in Reports [message #260458 is a reply to message #260410] Mon, 20 August 2007 00:54 Go to previous messageGo to next message
raniahalga
Messages: 6
Registered: August 2007
Junior Member

Just to suppress unwanted runtime messages..
Regards,
Rania
Re: System.message_level Equivalent in Reports [message #260461 is a reply to message #260458] Mon, 20 August 2007 01:00 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I see. What messages do you call "unwanted" when talking about reports? Could you name a few?
icon4.gif  Re: System.message_level Equivalent in Reports [message #260467 is a reply to message #260461] Mon, 20 August 2007 01:16 Go to previous messageGo to next message
raniahalga
Messages: 6
Registered: August 2007
Junior Member

In my report FORMULA there is a RAISE SRW.PROGRAM_ABORT during an EXCEPTION. Lines below:

EXCEPTION
WHEN NO_DATA_FOUND THEN
SRW.MESSAGE(1000,'THE AGENT CODE THAT YOU SELECTED CONTAINS NON DOLLAR VALUES');
RAISE SRW.PROGRAM_ABORT;

This ABORT throws two message windows.
1- REP-1419: 'c_sformula': PL/SQL program aborted.
2- REP-0594: No report output generated.

Actually I wanted to suppress these two message boxes.
Regards,
Rania
Re: System.message_level Equivalent in Reports [message #260515 is a reply to message #260467] Mon, 20 August 2007 03:41 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Thank you, it is much more clear now.

I'm afraid I can't help much; those messages are part of error stack and, as far as I can tell, can not be avoided. Sorry.

However, perhaps someone else knows how to do that.
icon4.gif  Re: System.message_level Equivalent in Reports [message #260810 is a reply to message #260515] Tue, 21 August 2007 00:41 Go to previous messageGo to next message
raniahalga
Messages: 6
Registered: August 2007
Junior Member

Thank you for your reply.

Since we can suppress informative messages in Forms, there should be a way in Reports too? what do you think...
Re: System.message_level Equivalent in Reports [message #260865 is a reply to message #260810] Tue, 21 August 2007 02:49 Go to previous message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, how about NOT aborting the report? Is it really necessary? Would something like this be OK?
EXCEPTION
  WHEN NO_DATA_FOUND THEN
  SRW.MESSAGE(1000,'THE AGENT CODE THAT YOU SELECTED CONTAINS NON DOLLAR VALUES');
This would show a message, but report would be created.

On the other hand, message text ('The agent code that you selected contains non dollar values') suggests that 'agent code' is selected from a list of values. So, why wouldn't you restrict values returned by LoV query. Something like
SELECT agent_code
FROM this_table
WHERE currency_values = 'DOLLAR'
This would make it impossible to choose unwanted values, Formula column query wouldn't return NO-DATA-FOUND and you wouldn't have to worry about program abortion.
Previous Topic: how to sum values from a different group
Next Topic: Oracle Reports on Web Browser
Goto Forum:
  


Current Time: Wed Dec 07 06:44:06 CST 2016

Total time taken to generate the page: 0.16247 seconds