Home » Developer & Programmer » Reports & Discoverer » RDF is OK but REP gives error REP-0736 (there is uncompiled program) (6.0.8)
RDF is OK but REP gives error REP-0736 (there is uncompiled program) [message #602686] Fri, 06 December 2013 13:40 Go to next message
bluetooth420
Messages: 146
Registered: November 2011
Senior Member
Hi

I have made a report which is working perfectly in report builder.

But when i try to run its REP file then it gives me REP-0736 error.

I have spotted a Formula Column. It has "complex loop and select". For the purpose of debugging, i commented the whole code of formula column and added a return(100). As a result, the report is working in RDF and REP but obviously with wrong results as return(100) is there instead of the required data.

Any tip that can help me out of the situation?

Note: I have searched the forum with REP-0736 but failed to find the solution. and i have compiled it with control+shift+k as well.

Thanks in Advance
Re: RDF is OK but REP gives error REP-0736 (there is uncompiled program) [message #602700 is a reply to message #602686] Sat, 07 December 2013 02:58 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Move code from that formula column into a stored (database) function. In report, just call that function which will return the correct value.
Re: RDF is OK but REP gives error REP-0736 (there is uncompiled program) [message #602719 is a reply to message #602700] Sat, 07 December 2013 14:09 Go to previous messageGo to next message
bluetooth420
Messages: 146
Registered: November 2011
Senior Member
Though i have tried to use "report function" and failed. But i will try "database function" and will let you know the results soon
Re: RDF is OK but REP gives error REP-0736 (there is uncompiled program) [message #602783 is a reply to message #602700] Mon, 09 December 2013 01:34 Go to previous message
bluetooth420
Messages: 146
Registered: November 2011
Senior Member
Littlefoot !!!!!!!!!!


You are awesome !

I love orafaq !!

Your idea worked perfectly on initial stages.

Will make all problematic Formula Column as database function soon to finish my this report.

Thanks once again.

-Dude
Previous Topic: Generate reports 6i to Thai output
Next Topic: ERROR :REP-1219 :R_1 has no size
Goto Forum:
  


Current Time: Thu Mar 28 15:28:46 CDT 2024