DbQuery Validation-Type Does Properly Error on Single Row Returned When ROWS_RETURNED="Z" Specified

(Doc ID 2199063.1)

Last updated on NOVEMBER 22, 2016

Applies to:

Oracle Utilities Network Management System - Version to [Release 1.12]
Oracle Network Management for Utilities - DMS - Version to [Release 1.12]
Information in this document applies to any platform.


The project has a custom text field in SWMAN_SAFETY_DOCS.CUST_ID.

When creating a new safety document of type CUSTOM1, they want to ensure that the operator does not use an existing CUST_ID value.

They have added this validation to their switching configuration:


This rule should generate an error dialog when one or more results are returned but there isn't an error until 2 or more results are returned.

Valid ROWS_RETURNED values are:
Z=no rows expected, S=single row expected, M=multiple rows expected




Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms