OraFAQ Forum: Reports & Discoverer » Report error

Home » Developer & Programmer » Reports & Discoverer » Report error (Oracle 10g, D2K forms, windows 7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Report error [message #600429]

Wed, 06 November 2013 09:54

thelearner
Messages: 133
Registered: April 2013
Location: INDIA

Senior Member

Hi,
I am getting below error while compiling the report in forms.

REP-0736: There exist uncompiled program unit(s). 
REP-1247: Report contains uncompiled PL/SQL.

I compiled in report builder and server side also but am getting same error.

1) I written an insert statement in before report statement.
but compiling Report in report builder and toad it is showing no errors.
If I run report from form it showing above error.
2)If I put comments the insert statement then it is working fine.

Report message to a moderator

Re: Report error [message #600445 is a reply to message #600429]

Wed, 06 November 2013 13:39

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Try to recompile both form and report with the "all" option (Ctrl + Shift + K). Then run it again.

Report message to a moderator

Re: Report error [message #600468 is a reply to message #600445]

Thu, 07 November 2013 01:49

thelearner
Messages: 133
Registered: April 2013
Location: INDIA

Senior Member

I compiled using (Ctrl+Shift+K) but it showing same thing.

Report message to a moderator

Re: Report error [message #600473 is a reply to message #600468]

Thu, 07 November 2013 02:44

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Could you post the whole Before Report trigger?

Report message to a moderator

Previous Topic:	Terminated with error: REP-300: Invalid Indentifier
Next Topic:	Report not opening after submit query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 17:28:59 CST 2025