As Craig said we need more info to help you: we need at least DB and Forms version and code you try to compile. There may be a plenty of reasons for such error. I just guessing, but I think that you use in code some feature which is not supported by Oracle Forms PL\SQL engine and is supported by database version you use, but I'm just guessing. Let us chance to help you.
When I check on Help its showing Forms Version as : 220.127.116.11.3
I have compiled many other packages before and its not the first form I am using after the installation.
Currently I am modifying the existing form that was working good previously.
I investigated on that and the thing I observed is to the procedure code which is getting called in the form, I have added a new call to a procedure using dblink. When I am removing that procedure call its working fine.
Does anybody has idea why this is happening like that?
One more strange thing what I observed is:
I have moved the procedure that is available in the current schema to the destination schema which was getting accessed from dblink.
I created a synonym for the procedure in the current schema and I called the same procedure in the form, its working fine.
But this is not possible for all the cases, so someone please help me to sort out this issue.
You are using a very much out-of-date version of Forms. At the very least, you should upgrade Forms to the latest Forms 6i, by applying Patch 18. That will bring you up to 18.104.22.168.0 Even at that level, Oracle does not support it, but some of us are still using it.
I think there have always been problems using database links, so I am not sure what your solution would be. ...maybe build procedures that run on the database to do the work, instead of from within your form, when they need to use database links. Then, call those procedures from your form.