FRM-41214: Oracle Forms/Reports problem

[sati_82]

Hi!

I'm getting the FRM-41214 error when trying to run a report from a
form. DB used is Oracle 10g. Oracle Forms & Reports are in version 10.
I know from looking on the web that there is several possible root
cause, but I think neither fits to my situation.
In my case, I'm getting the FRM-41214 error only for certain parameter
values sent to the report server (i.e. when one of the parameter is
set to '1995' reports ends with success but when the same parameter is
set to '1997' value I'm getting FRM-41214). Any idea why is it
happening? Or where to track the cause of error?

Best regards,
Krystian

[sati_82]

Hi!

Additional information about it is that from the sever I get a
message:

"Terminated with error: REP-1401: 'pc_hold2formula': Fatal PL/SQL
error occurred. ORA-01476: divisor is equal to zero"

when executing report with error.

Best regards,
Krystian

[sati_82]

Additional information is that from the server I get:

"Terminated with error: REP-1401: 'pc_hold2formula': Fatal PL/SQL
error occurred. ORA-01476: divisor is equal to zero"

when executing the report with error.

Best regards,
Krystian

[Shakespeare]

"sati_82" <krys...@interia.pl> schreef in bericht
news:1187868891.0...@q4g2000prc.googlegroups.com...

The error says it all: somehow your query over 1997 causes a division by
0...... so there must be a value of 0 somewhere in your data, zero records
returned (while calculating an average) or other error in your query or
code....

Shakespeare

[sati_82]

Thanks for your advice! In fact, in my program code there is an
attempt to divide by 0. Surly this is the cause of error.

Krystian