Re: Uncompiled PLSQL in Purchasin Report

From: STiger2000 <stiger2000_at_my-deja.com>
Date: Sun, 10 Dec 2000 07:25:47 GMT
Message-ID: <90vb5q$rjm$1@nnrp1.deja.com>

If I'm understanding correctly ...
you've regened the report, but the error is coming from PL/SQL that the report uses. I think adadmin has an option to recompile components (I'm away from my docset now, so this is a guess). If you are familiar with OEM, it can also be used to find (and fix) INVALID objects. jc

In article <90rnok$bod$1_at_lore.csc.com>,
"fred" <fred_at_fred.com> wrote:
> We have installed Oracle Purchasing on our 10.7NCA installation,
(Patch set
> O). When we attempt to print our Purchase Orders we get the following
> error:
>
> REP-0736: There exist uncompiled program unit(s).
> REP-1247: Report contains uncompiled PL/SQL.
>
> This is an HP/UX install and I have regen'd the report at the UNIX
level
> using "r25convm" and have converted the rdf to an rex file and back
to the
> rdf file with no luck.
>
> The problem appears to be how to get the PL/SQL units compiled.
R25convm is
> supposed to do this but apparently it doesn't work.
>
> thanks
>
> Kevin
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Dec 10 2000 - 01:25:47 CST