Dbexecute Does Not Detect The ORA-01873 Error
(Doc ID 2568126.1)
Last updated on JULY 26, 2022
Applies to:Oracle Communications Billing and Revenue Management - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
On : BRM 220.127.116.11.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?
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