Hi
I was trying to set up a validation that End Date must be larger than Start Date.
I referred the article here: https://community.oracle.com/thread/2560865
And tried:
Type: Function Returning Error Text
Validation Expression 1
Begin
If to_date(:P12_ENDDATE,'DD-MON-YYYY') < (:P12_STARTDATE,'DD-MON-YYYY') then
Return 'End Date should be greater than Start Date';
Else
Return null;
End if;
End;
However, got error
Error processing validation.
ORA-06550: line 3, column 40: PLS-00412: list of values not allowed as argument to this function or procedure ORA-06550: line 3, column 1: PL/SQL: Statement ignored
Does anyone can help me take a look?
Thank you!!
Alice
