OraFAQ Forum: Forms » DATABASE LINK in Forms

Home » Developer & Programmer » Forms » DATABASE LINK in Forms

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

DATABASE LINK in Forms [message #205073]

Thu, 23 November 2006 04:25

simple_ora
Messages: 50
Registered: September 2006
Location: UAE

Member

Hi Guys
I have searched this forum,but not get anything...

I am using dblink in forms,its jumping out when i compile it..
,i can use that link from sql * plus,...
Regrads
Shefi...

Report message to a moderator

Re: DATABASE LINK in Forms [message #205087 is a reply to message #205073]

Thu, 23 November 2006 05:01

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

Senior Member
Account Moderator

simple_ora

its jumping out when i compile it

What does it mean? Could you explain it - if that's not a problem - using Oracle-related language?

Report message to a moderator

Re: DATABASE LINK in Forms [message #205097 is a reply to message #205073]

Thu, 23 November 2006 05:24

shahidmughal
Messages: 91
Registered: January 2006
Location: Faisalabad Pakistan

Member

hi
please clearly explain your problem
i cannot help you until you clear your problem.

wishing well for you

Report message to a moderator

Re: DATABASE LINK in Forms [message #205186 is a reply to message #205073]

Thu, 23 November 2006 17:39

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Are you using the same userid for both SQL*Plus and Forms?

David

Report message to a moderator

Re: DATABASE LINK in Forms [message #205997 is a reply to message #205186]

Tue, 28 November 2006 05:46

simple_ora
Messages: 50
Registered: September 2006
Location: UAE

Member

Hi Guys

I am connecting to Database Wich is on a server say 'SERV06', I am trying it from my local mechene
This link is working if i use it in PlSQL ,But in the form its not working,When i compile the form its Automatically closing the form Builder itself.

Link Eg: -

Create Dadabase Link Jlink connect to sami identified by sami
using 'prod'

I am creating this link in local database

...
Thanks & Regrads

Shefiq

Report message to a moderator

Re: DATABASE LINK in Forms [message #206114 is a reply to message #205997]

Tue, 28 November 2006 17:44

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Okay ... I think what we have here is the "mismatched tnsnames.ora files" problem. Please search this forum for 'tnsnames ifile' and review the threads.

Basically, when you installed the database on your PC an entry defining the database was created in the Database's Oracle Home but when you installed Forms on the same machine this information was not placed in the Form's Oracle Home.

David

Report message to a moderator

Re: DATABASE LINK in Forms [message #206189 is a reply to message #206114]

Wed, 29 November 2006 02:07

simple_ora
Messages: 50
Registered: September 2006
Location: UAE

Member

Hi
So should i edit the tnsname file of oracle forms...?,What's
the change should be ...?
Thanks & Regards
Shefiq

Report message to a moderator

Re: DATABASE LINK in Forms [message #206279 is a reply to message #206189]

Wed, 29 November 2006 07:29

ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India

Senior Member

you should have installed D2K first then Oracle. You will not face problem in that case.

Bye
Ashu

Report message to a moderator

Re: DATABASE LINK in Forms [message #206384 is a reply to message #206279]

Wed, 29 November 2006 18:27

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Ashutosh,

I don't know which version of Oracle you are using but I have found that installing the database and then forms is the way to go. Of course, you have to get the tnsnames and listener files to match.

David

Report message to a moderator

Previous Topic:	one side oval shaped push button
Next Topic:	migration from 6i to 10gforms-alternate for d2kwutil.pll ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 13:34:04 CDT 2024