Home » Developer & Programmer » Forms » Compile Form Won't Stop
Compile Form Won't Stop [message #261138] Tue, 21 August 2007 23:43 Go to next message
cecilkur
Messages: 4
Registered: August 2007
Location: Indonesia
Junior Member
Hello
My name is cecilia
I am new in oracle, I have a difficulty using form builder
This is the condition:
I am using oracle database 10g and oracle developer 10g
In my database server there are 2 database (global and branch)
In global there are database link to branch and store procedure insert to branch using database link

Now I want to run this store procedure using form builder
In my form, there is a button and trigger when button pressed
In the trigger, I wrote
begin
copycustomer();
end;

When I compile this pl/sqlcode, My CPU process was 100% for oracle.exe and it won't stop compiling.

Can anyone help me? I want to know what is the problem and solution for it..

Thank you
Smile
Re: Compile Form Won't Stop [message #261584 is a reply to message #261138] Thu, 23 August 2007 01:37 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Is this the first form with which you have worked? If yes, then I suggest you try working with the 'test' form and see if you have the same problem.

David
Re: Compile Form Won't Stop [message #261607 is a reply to message #261584] Thu, 23 August 2007 02:12 Go to previous message
cecilkur
Messages: 4
Registered: August 2007
Location: Indonesia
Junior Member
No, this is not my first form

If I compile store procedure that doesn't databaselink, I can run the form.

But I can solve it, by changing mu databaselink with synonim.
So form compiler will not see @ in my store procedure

Thank for you attention


Cecilia
Previous Topic: Ask For Forms_ddl
Next Topic: tutorial ford2k
Goto Forum:
  


Current Time: Fri Dec 09 15:48:48 CST 2016

Total time taken to generate the page: 0.25741 seconds