I have written a function which takes two parameters and returns 'Y' or 'N' .
Can I get the syntax how I can call the function in the condition block.
My syntax is (apps.validate_location is the user function).
I get the following error
The condition =apps.validate_location(:ASSGT.ASSIGNMENT_NUMBER,:ASSGT.LOCATION_CODE)
could not be evaluated because of error ORA-00936: missing expression
I am strglling with the same kind of problem......
I tried all the way to pass the form fields values as parameter...... But its not working...
when you will give a hardcoded value then your procedure will accept it...
i think through form personalization we cant pass the FORM field values in to procedures....