My Oracle Support Banner

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

Last updated on JANUARY 26, 2024

Applies to:

Oracle Reports Developer - Version and later
Oracle Forms for OCI - Version 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

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