I have a parameter report that simply refuse to return data. The sql works, it fetches the correct data, but when I run it with the parameter, it fails.
In the validation event, I tried:
:P_MOC := RTRIM(UPPER(:P_MOC));
to no avail.
I also tried to do it as a lexical with the value 'whatever user entered%'
I then tried passing it as a lexical in the query, and get an error message claiming it is an invalid field.
WHERE moc.moc_name LIKE &P_MOC
If I do WHERE moc.moc_name = :P_MOC, it runs, but fails to return any records, even with the data typed exactly
In my test case, the value for the parameter is PLT, and it should return 70+ pilots. It does not.