Validate Row

VALIDATE_ROW is a PL/SQL procedure that get's called when a "Server Validate on Change" property is set on an editable field (TextField, LOV, ComboBox, CheckBox, NumberField, DateField etc)

When do we use it?

It can be used to check whether the value changed by the user on the UI is valid selection or not.

It can be used to fetch some extra columns from the DB to show in the UI.

Basically if a value change in the field requires interaction with the database, then VALIDATE ROW can be used.

Examples?

PROCEDURE VALIDATE_ROW(
P_COUNTRY IN OUT VARCHAR2
, P_CUST_ACCOUNT_ID IN OUT NUMBER
, P_PERSON_FIRST_NAME IN OUT VARCHAR2
, P_PERSON_LAST_NAME IN OUT VARCHAR2
, P_WEB_ORDER IN OUT VARCHAR2
, P_CHANGED_ATTRIBUTE IN OUT VARCHAR2
, P_CHANGED_ATTRIBUTE_OLD_VALUE IN OUT VARCHAR2
) AS
api_error EXCEPTION;
PRAGMA EXCEPTION_INIT (api_error, -20001);
l_return_code VARCHAR2(1) := 'S';
l_msg_data VARCHAR2(4000);
BEGIN
IF (P_COUNTRY = 'US') THEN
P_WEB_ORDER = 'WB-US-';
END IF
END VALIDATE_ROW;

Related Topics: Client Side Validation, Server Side Validation, Reset Form Panel, Condition, Expression, Object Handler

Location

101 California Street, Suite 2710
San Francisco, CA 94111


440 N. Wolfe Rd.
Sunnyvale, CA 94085


Office 11, 5th Floor, Building 9,
Mindspace IT Park
Hyderabad 500081

p: +1 (844) AT CloudIO (844-282-5683)
f: +1 (650) 300-5247 | e: sales@cloudio.io
© 2009, 2017 CloudIO Inc. | Terms of Use | Privacy Policy