Re: FRM-41214: Oracle Forms/Reports problem

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Thu, 23 Aug 2007 14:32:56 +0200
Message-ID: <46cd7e7d$0$230$e4fe514c@news.xs4all.nl>

"sati_82" <krys_tek_at_interia.pl> schreef in bericht news:1187868891.096211.122170_at_q4g2000prc.googlegroups.com...
> 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
>

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 Received on Thu Aug 23 2007 - 07:32:56 CDT