My Oracle Support Banner

Dbexecute Does Not Detect The ORA-01873 Error (Doc ID 2568126.1)

Last updated on JULY 29, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.17.0 and later
Information in this document applies to any platform.

Symptoms

On : BRM 7.5.0.17.0 version, Pipeline Manager, on Production environment

PRE_PROCESS pipeline has configured a function which is executing an iScript file.

In the iScript, dbexecute is run in order to fetch data from a custom view having two columns: IMSI and PBR_END_TS

As per view definition, it is created based on data from one custom table having two columns: IMSI and SIM_PBR_END_T, second one holding an Unix time.

See below the DDL statements for the database custom objects involved in this scenario:

The problem is that in case the invalid Unix time is located on a row which has ROWNUM greater than 100, pipeline manager i able to start as dbexecute does not detect the ORA-01873 error.

EXPECTED BEHAVIOR

-----------------------

pipeline manager should not be able to start if there is one row having invalid Unix time no mater the rownum

Cause

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
Symptoms
Cause
Solution
References


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