lunes, 6 de julio de 2015

SOLVED: ORACLE REPORTS ora-24323 FUNCTION TABLE

CASE 1  resolved
1. When you call the report the report runtime hangs and show this error.
2. if you copy the function table to the sqlplus and execution using the same parameters, you get disconnected.3. The way we solved the problem, was modifying two times  (adding a null; recompile, adding another null; and recompile)
4. execute from sqlplus and don't get disconnect.
5. execute the report and the error dissapear.

CASE 2 unresolved
1. When you call the report the report runtime hangs and show this error.
2. if you copy the function table to the sqlplus and execution using the same parameters, you DON'T get disconnected.
3. You can recreate the report, or as we do recreate the report in jasper, because we are migrating our reports, from oracle reports 6i.