My Oracle Support Banner

How to Stop Execution of a Scheduled Job that Would Create no Content (Doc ID 1270328.1)

Last updated on APRIL 04, 2021

Applies to:

Oracle Reports Developer - Version 10.1.2.3 and later
Information in this document applies to any platform.

Goal

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.






Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.