| Compile Form Won't Stop [message #261138] |
Tue, 21 August 2007 23:43  |
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
|
|
|
|
|
|
| Re: Compile Form Won't Stop [message #261607 is a reply to message #261584] |
Thu, 23 August 2007 02:12  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
