Home » Developer & Programmer » Reports & Discoverer » REP-1247: Report contains uncompiled PL/SQL
icon14.gif  REP-1247: Report contains uncompiled PL/SQL [message #229118] Thu, 05 April 2007 08:09 Go to next message
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
icon14.gif  Re: REP-0736: There exists uncompiled program unit(s). [message #229119 is a reply to message #229118] Thu, 05 April 2007 08:20 Go to previous messageGo to next message
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)."

Re: REP-0736: There exists uncompiled program unit(s). [message #229149 is a reply to message #229119] Thu, 05 April 2007 09:43 Go to previous messageGo to next message
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.
Re: REP-0736: There exists uncompiled program unit(s). [message #229184 is a reply to message #229149] Thu, 05 April 2007 15:12 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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>).
Re: REP-1247: Report contains uncompiled PL/SQL [message #288331 is a reply to message #229118] Mon, 17 December 2007 02:07 Go to previous messageGo to next message
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
Re: REP-1247: Report contains uncompiled PL/SQL [message #552455 is a reply to message #288331] Thu, 26 April 2012 00:28 Go to previous messageGo to next message
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 !!!
Re: REP-1247: Report contains uncompiled PL/SQL [message #552606 is a reply to message #552455] Thu, 26 April 2012 18:14 Go to previous message
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:
  


Current Time: Fri Mar 29 05:21:33 CDT 2024