OraFAQ Forum: Reports & Discoverer » REP-1247: Report contains uncompiled PL/SQL

Home » Developer & Programmer » Reports & Discoverer » REP-1247: Report contains uncompiled PL/SQL

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

REP-1247: Report contains uncompiled PL/SQL [message #229118]

Thu, 05 April 2007 08:09

owhite
Messages: 2
Registered: April 2007
Location: nyc

Junior Member

Hi, I am getting this error message "REP-1247: Report contains uncompiled PL/SQL" whenever I run the Page Layout in Oracle Reports Developer. Is anyone familiar with this problem?

O'Neil

Report message to a moderator

Re: REP-0736: There exists uncompiled program unit(s). [message #229119 is a reply to message #229118]

Thu, 05 April 2007 08:20

owhite
Messages: 2
Registered: April 2007
Location: nyc

Junior Member

I am also getting these error messages: "REP-0736: There exists uncompiled program unit(s)."

Report message to a moderator

Re: REP-0736: There exists uncompiled program unit(s). [message #229149 is a reply to message #229119]

Thu, 05 April 2007 09:43

tllocke
Messages: 22
Registered: March 2006

Junior Member

The only way I get around this (if I have zero idea which unit isn't compliled) is go into the PL/SQL editor and complile each one at a time... it's time consuming if you have many in your report, but it's the only way I get rid of this error myself.

Report message to a moderator

Re: REP-0736: There exists uncompiled program unit(s). [message #229184 is a reply to message #229149]

Thu, 05 April 2007 15:12

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

Senior Member
Account Moderator

There's no need to compile every single PL/SQL unit one by one. Compile ALL at once: either using menu (Program - Compile - All) or using a shortcut (<Ctrl + Shift + K>).

Report message to a moderator

Re: REP-1247: Report contains uncompiled PL/SQL [message #288331 is a reply to message #229118]

Mon, 17 December 2007 02:07

white_phoenix
Messages: 19
Registered: November 2007

Junior Member

owhite wrote on Thu, 05 April 2007 08:09

Hi, I am getting this error message "REP-1247: Report contains uncompiled PL/SQL" whenever I run the Page Layout in Oracle Reports Developer. Is anyone familiar with this problem?

O'Neil

you get this error because you're trying to run a report (and yes by clicking on page layout, means run the report) but you have edit pl/sql without compiling it. simply compile all and run again

Report message to a moderator

Re: REP-1247: Report contains uncompiled PL/SQL [message #552455 is a reply to message #288331]

Thu, 26 April 2012 00:28

JMROX
Messages: 2
Registered: February 2012
Location: COLOMBO

Junior Member

Hi all

I am getting the same error.... I compile the report again using the report builder it compiles perfectly in report builder 6i... but it gives the same error... when i run the report in the system.
(many reports)

I recently compile the Pll files and i compile all the forms in the system accordingly that's the only change i did, please help me to sort out this

Thanx in advance !!!

Report message to a moderator

Re: REP-1247: Report contains uncompiled PL/SQL [message #552606 is a reply to message #552455]

Thu, 26 April 2012 18:14

perry0511
Messages: 5
Registered: April 2012

Junior Member

Compile the PL/SQL, then run your report.

Oracle error database REP-01247

[Updated on: Thu, 26 April 2012 18:15]

Report message to a moderator

Previous Topic:	export to excel failing
Next Topic:	Problem in printing pdf report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 31 18:51:50 CDT 2025