Re: I really need help. Please - ASAP

I've had this before in very similar situations. What you'll probably find as the problem is that at runtime the Oracle user who is actually running the report does not have the correct privaleges grante on at least one object in the report. This will cause you to get uncompiled units error at runtime. This basically means that you are runnign the report as a different oracle user to that when testing it. Check who you log in to Oracle as when you log in to Applications and check their privs.

Alternatively, and this was my situation, I developped on the test database and put the code live on another and forgot to assign the privs to the same user on the live database.

--
Alan D. Mills

azhan98_at_tm.net.my wrote in message <6vjrqs$ldd$1_at_nnrp1.dejanews.com>...
>I'm developing some customize report (Using Report 2.5) which will insert
>certain data into my customized table.This for sure requires some PL/SQL
>statement as part of the report. I have test the report in the Report 2.5
>application and it work as what I need. When I put the report on the server
>and group it as one of my Oracle Application (Oracle Manufacturing) report,
>it says "There exist uncompiled program unit" in my report. I know the
>compilation is not the problem because there is no error.
>

<BIG SNIP> Received on Fri Oct 09 1998 - 06:25:38 CDT