How to Stop Execution of a Scheduled Job that Would Create no Content
(Doc ID 1270328.1)
Last updated on MAY 27, 2023
Applies to:Oracle Reports Developer - Version 10.1.2.3 and later
Information in this document applies to any platform.
Imagine scheduled Reports which are executed automatically.
In some scenario there might be no data or any other reason, which would result in a blank output. For example a scheduled email report would be sent with no content or blank attachments.
The goal of this document is to provide a solution which is able to detect these situations and is able to suppress such jobs.
The solution discussed here resides in Oracle Reports based PL/SQL coding and takes advantage of build-in function SRW.PROGRAM_ABORT.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document