Dbexecute Does Not Detect The ORA-01873 Error
(Doc ID 2568126.1)
Last updated on JANUARY 03, 2024
Applies to:
Oracle Communications Billing and Revenue Management - Version 7.5.0.17.0 and laterInformation 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 |