OraFAQ Forum: Forms » Form Exists when using the Data Link

Home » Developer & Programmer » Forms » Form Exists when using the Data Link (Oracle 10g, Forms 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: Form Exists when using the Data Link [message #534304 is a reply to message #534303]

Mon, 05 December 2011 03:39

Littlefoot
Messages: 21817
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm sorry, but I don't understand the question.

What is a "datalink from the SQL"? How do you put "it" into a form? Should "it exists" be "it exits"? If so, what does it mean? Does the Forms Builder crash?

Could you provide some more details, please? What operating system do you use?

Report message to a moderator

Re: Form Exists when using the Data Link [message #534306 is a reply to message #534304]

Mon, 05 December 2011 03:47

elsy
Messages: 40
Registered: August 2006
Location: Kuwait

Member

I am using a Database Link . From Sql its working fine but when using the same databaselink in Form 6i , it just exits from the Form Builder when trying to compile it

Report message to a moderator

Re: Form Exists when using the Data Link [message #534308 is a reply to message #534306]

Mon, 05 December 2011 03:53

cookiemonster
Messages: 13931
Registered: September 2008
Location: Rainy Manchester

Senior Member

How are you trying to use the DB link in the form?

Report message to a moderator

Re: Form Exits when using the Database Link [message #534309 is a reply to message #534308]

Mon, 05 December 2011 03:57

elsy
Messages: 40
Registered: August 2006
Location: Kuwait

Member

select * from tablename@databaselinkname

Report message to a moderator

Re: Form Exits when using the Database Link [message #534310 is a reply to message #534309]

Mon, 05 December 2011 04:09

cookiemonster
Messages: 13931
Registered: September 2008
Location: Rainy Manchester

Senior Member

Is that in trigger code, a program unit, LOV? something else?

Report message to a moderator

Re: Form Exits when using the Database Link [message #534311 is a reply to message #534310]

Mon, 05 December 2011 04:14

elsy
Messages: 40
Registered: August 2006
Location: Kuwait

Member

Its in the When Validate Item trigger of Text Box

Report message to a moderator

Re: Form Exits when using the Database Link [message #534313 is a reply to message #534311]

Mon, 05 December 2011 04:27

cookiemonster
Messages: 13931
Registered: September 2008
Location: Rainy Manchester

Senior Member

Create a view for:

select * from tablename@databaselinkname

Then query the view in the trigger.

Report message to a moderator

Re: Form Exits when using the Database Link [message #534314 is a reply to message #534313]

Mon, 05 December 2011 04:34

elsy
Messages: 40
Registered: August 2006
Location: Kuwait

Member

yes , its working

Thanks a lot

can u tell me why its not working with the databaselink name but with the view

Report message to a moderator

Re: Form Exits when using the Database Link [message #534318 is a reply to message #534314]

Mon, 05 December 2011 04:58

cookiemonster
Messages: 13931
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.

Report message to a moderator

Re: Form Exits when using the Database Link [message #534319 is a reply to message #534318]

Mon, 05 December 2011 05:01

elsy
Messages: 40
Registered: August 2006
Location: Kuwait

Member

Thank You .Thanks a lot for your support

[Updated on: Mon, 05 December 2011 05:02]

Report message to a moderator

Previous Topic:	Migration Forms (FMBs,PLLs,MMBs) from Forms 6i to Forms 11g
Next Topic:	uploded/download files

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Aug 09 15:15:03 CDT 2024