Hi all,

I have created a function called Get_Dt using "Create or Replace function". I have given grants to public and have created a public synonym also. It works well. But sometimes when i do some modification to any form and try compile it i get a error message like "Identifier Get_Dt must be declared, Statement ignored". But at the same time the other compiled programs using this function are working well.

This error message also will appear for some time only. Later if i try to compile the same program it compiles well and works. Really this irritates since the problem is very difficult to understand. Even i tried to re-create the function several times. Kindly help me pls.

We are using oracle version 7.1

Thanks in adv.

Regs

Pvl


[Edited by pvl on 08-13-2001 at 03:17 AM]