I have two filed Price and Cost If Price < Cost I should get an error saying Item Price Should be Greater Item Than Cost I need to created Validation In Oracle Apex
-
stackoverflow.com/help/how-to-askbrenners1302– brenners13022019-05-15 05:42:29 +00:00Commented May 15, 2019 at 5:42
-
Have you looked at the documentation/tutorials for creating validations? What have you tried?Scott– Scott2019-05-15 05:48:43 +00:00Commented May 15, 2019 at 5:48
-
I know how to create validation. I am asking how to implement this or write this code.Rahmatullah– Rahmatullah2019-05-15 05:57:42 +00:00Commented May 15, 2019 at 5:57
Add a comment
|
2 Answers
That would be a validation of a "PL/SQL function which returns error text" type.
if :P1_PRICE < :P1_COST then
return 'Item price should be greater than cost';
end if;
return null;
Comments
You can create two item as like :P0_PRICE and :P0_COST After that you Create a validation of type "Function Body returning Boolean" with source code
BEGIN
IF :P0_PRICE < :P0_COST THEN
RETURN true;
END IF;
RETURN false;
END;
