My Oracle Support Banner

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

Last updated on JUNE 09, 2020

Applies to:

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

Goal

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:

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

Is this a product defect?

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
References


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