Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Reports 2.5 problem

Re: Reports 2.5 problem

From: George Rapp <gwr_at_oasis.novia.net>
Date: 1997/03/12
Message-ID: <5g6v11$hmi@nntp.novia.net>#1/1

: Noriko <noriko_at_noriko.com> wrote in article
: <33111697.2B7F_at_hkusua.hku.hk>...

: > I created a report using the Oracle Report 2.5. But I can only run the
: > .rdf files. Every time I want to run the report from the .rep file
: > generated from the .rdf source file, the report runtime prompt me with:
: >
: > REP-0735: Unable to load DE Program Unit. Will try to load PL/SQL source
: > texts. Make sure you are connected to a database.
: >
: > After I pressed OK. I prompt me with:
: >
: > REP-0736: There exists uncompiled program unit.
: >
: > And then return without giving me the parameter window.
: >
: > Anyone who have encounter the same problem? Or anyone know what's the
: > problem?

I saw this error when I had not GRANTed SELECT on a table referenced in one of my report triggers (BEFORE PARAMETER FORM) to anybody but SYSTEM. Since I develop reports as SYSTEM, I could see the table fine; anybody else got the error message you mentioned above.

As mentioned elsewhere in the thread, also try File -> Compile All in the .RDF version (while using R25DES, of course, not R25RUN) before you convert the .RDF to an .REP next time.

Hope that helps.

George

-- 
George Rapp   EDS - DFAS Electronic Document Management Partnership  
Postal: DFAS-OM, Attn. EDS, 901 SAC Blvd., Offutt AFB, NE  68113-5680
Phone: 402/232-3446   DSN: 272-3446  Fax: 402/232-3453  gwr_at_novia.net
"Windows is a 'fault-driven' system ..." - Hurricane 2.01 software manual
Received on Wed Mar 12 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US