Form Exists when using the Data Link [message #534303] |
Mon, 05 December 2011 03:18 |
elsy
Messages: 40 Registered: August 2006 Location: Kuwait
|
Member |
|
|
Dear All,
I am using Forms 6i and oracle 10 g . I am able to use the datalink from the SQL. But when i put it in the form, and try to compile, it exists from the form builder.
Kindly help
Thanks
Elsy
Kuwait
|
|
|
|
|
|
|
|
|
|
|
Re: Form Exits when using the Database Link [message #534318 is a reply to message #534314] |
Mon, 05 December 2011 04:58 |
cookiemonster
Messages: 13938 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Because forms 6i has an old and buggy sql engine that doesn't like all sorts of DB features, not just db links. It'll certainly reject any new feature of sql and pl/sql added from 9i onwards.
It works now because forms sql engine doesn't care what the view is doing.
You really should upgrade to a version of forms that matches your DB version.
|
|
|
|