I am calling a procedure in WHEN-BUTTON-PRESSED trigger in a form.
The compilation is getting stuck in the middle when the compilation reaches this trigger.
But when I compile the procedure that is called in the form from outside, its getting compiled successfully.
Can any body help me on this. Please let me know what might be the reason for this.
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.
Thanks Craig and Kikolus. I will definitely go through the links you mentioned.
Here are some more details for the above mentioned issue:
Forms version: 6.0
Oracle DB: 10g
I am trying to compile a package call inside the trigger. I am not facing any error but the Form is getting stuck without getting compiled.
I waited for hours but still its in the same state.
I thought that the procedure has errors but though I re-compiled the procedure separately and compiled the form its still getting stuck.
Can you please let me know what might be the reasons for this issue so that I can work from my side.
You may be using an incompatible version of Forms....
What computer platform are you working on?
In Forms Builder, when you click Help, About, what full Forms Version does it report?
Can you compile any other form that calls any package procedure or stored procedure? Or is this the first time you have tried that with your Forms Developer setup?
Is this a form you are building from scratch, or one built somewhere else that you are modifying?
I am working on Windows XP.
When I check on Help its showing Forms Version as : 184.108.40.206.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 220.127.116.11.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.