OraFAQ Forum: Reports & Discoverer » System.message

Home » Developer & Programmer » Reports & Discoverer » System.message_level Equivalent in Reports

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

System.message_level Equivalent in Reports [message #260307]

Sat, 18 August 2007 05:13

raniahalga
Messages: 6
Registered: August 2007

Junior Member

Hi friends,

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

Regards,
Rania

Report message to a moderator

Re: System.message_level Equivalent in Reports [message #260410 is a reply to message #260307]

Sun, 19 August 2007 10:54

Littlefoot
Messages: 21813
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?

Report message to a moderator

Re: System.message_level Equivalent in Reports [message #260458 is a reply to message #260410]

Mon, 20 August 2007 00:54

raniahalga
Messages: 6
Registered: August 2007

Junior Member

Just to suppress unwanted runtime messages..
Regards,
Rania

Report message to a moderator

Re: System.message_level Equivalent in Reports [message #260461 is a reply to message #260458]

Mon, 20 August 2007 01:00

Littlefoot
Messages: 21813
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?

Report message to a moderator

Re: System.message_level Equivalent in Reports [message #260467 is a reply to message #260461]

Mon, 20 August 2007 01:16

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

Report message to a moderator

Re: System.message_level Equivalent in Reports [message #260515 is a reply to message #260467]

Mon, 20 August 2007 03:41

Littlefoot
Messages: 21813
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.

Report message to a moderator

Re: System.message_level Equivalent in Reports [message #260810 is a reply to message #260515]

Tue, 21 August 2007 00:41

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...

Report message to a moderator

Re: System.message_level Equivalent in Reports [message #260865 is a reply to message #260810]

Tue, 21 August 2007 02:49

Littlefoot
Messages: 21813
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.

Report message to a moderator

Previous Topic:	how to sum values from a different group
Next Topic:	Oracle Reports on Web Browser

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 04 11:42:26 CDT 2024