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 22.214.171.124.0 and later
Information in this document applies to any platform.
On : BRM 126.96.36.199.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.
pipeline manager should not be able to start if there is one row having invalid Unix time no mater the rownum
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