Thursday, 3 September 2009

FRM-41214 : Unable to run report

Recently I found FRM-41214 error while try to run report from Form. All of them work well on Report Builder.
So, I assume there are sumtin wrong with my LOC on forms.
I found source of the problem, which r I send date parameter as string with conversion/cast. [to_char(:date_from,'dd-mm-rrrr')]
So, u may send date as string but never ever try to cast it to string/char.
Well, thats sure means we cant send wrong parameter type.