Re: HELP! ORACLE Reports Question

Per Brondum wrote:

>
> Check to see if you are referencing a source (TABLE) in your PL/SQL that
> is owned by that particular user. Typically that is the case.
>
> BTW, if that is the case and you are hitting the database a lot, you
> might want to consider moving the functionality to a stored procedure,
> possibly resulting in better performance.
>
> If your functions are not referencing table's let me know !
>
> --
> Per Brondum
> Developer/2000

-- 

Hi Per:
	I have been having the same problems for a long time. Let me
explain you the exact problem and when it comes up.
	
	When I create a report with formula columns with or with out referencing tables, 
I am OK when I create it for the first time and then run it. But the problem is when we 
open the Same Report again in the Reports Designer later on, the above messages comes up. 
But then after I open it and then compile the whole stuff it works fine. I do not why 
those error messages comes up when ever I open an old report.
	Please suggest me appropriately.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Sreedhar V. Lokam
Address: 5124, Heather Dr. #101,
	 Dearborn, MI	48126

Phone: (313)-441-2337 (H)
       (313)-996-7687 (W)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~