OraFAQ Forum: Forms » Use of DB Link in D2K Form and report 6i

Home » Developer & Programmer » Forms » Use of DB Link in D2K Form and report 6i (Oracle 10G,D2K Forms And Report 6i)

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

Use of DB Link in D2K Form and report 6i [message #475604]

Thu, 16 September 2010 01:45

manojkumarg2gmailcom
Messages: 5
Registered: September 2010
Location: Bhopal

Junior Member

Is any one can help me how to use of Database link (DBLINK) in D2K form and report PL/SQL.When I Use the DB Link in Pl/SQL of any form6i or report 6i, On compilation forms and reports are automatically closed .Is there any usage problem or system problem.

Thanks

Manoj Gupta

Report message to a moderator

Re: Use of DB Link in D2K Form and report 6i [message #475608 is a reply to message #475604]

Thu, 16 September 2010 01:57

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

Senior Member
Account Moderator

A workaround might be this: create a database link (obviously, you need it). In a current schema create a SYNONYM to objects via database link. In a form, use newly created synonyms (instead of tables@database_link).

Report message to a moderator

Re: Use of DB Link in D2K Form and report 6i [message #476377 is a reply to message #475608]

Thu, 23 September 2010 00:00

manojkumarg2gmailcom
Messages: 5
Registered: September 2010
Location: Bhopal

Junior Member

Thanks for you reply.
here create SYNONYM means, Create database view based on the database link for each table and then use these view directly.

Is there any way to access all table in particular database or user
without create view of each table.

Thanks

Manoj Gupta

Report message to a moderator

Re: Use of DB Link in D2K Form and report 6i [message #476381 is a reply to message #476377]

Thu, 23 September 2010 00:35

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

Senior Member
Account Moderator

Synonym is not a view.

A database link is what you need - that's true. But, if you can't make the form work when accessing tables over a database link, then you need another way. I don't know of any other, different from what I already suggested.

Report message to a moderator

Previous Topic:	How many minimum NUP licenses for Oracle 10g AS Enterprise Edition we have to purchase?
Next Topic:	Internet and Developer 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 02:30:29 CST 2025