Home » Developer & Programmer » Forms » DATABASE LINK in Forms
icon14.gif  DATABASE LINK in Forms [message #205073] Thu, 23 November 2006 04:25 Go to next message
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...
Re: DATABASE LINK in Forms [message #205087 is a reply to message #205073] Thu, 23 November 2006 05:01 Go to previous messageGo to next message
Littlefoot
Messages: 20900
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?
Re: DATABASE LINK in Forms [message #205097 is a reply to message #205073] Thu, 23 November 2006 05:24 Go to previous messageGo to next message
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
Re: DATABASE LINK in Forms [message #205186 is a reply to message #205073] Thu, 23 November 2006 17:39 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Are you using the same userid for both SQL*Plus and Forms?

David
Re: DATABASE LINK in Forms [message #205997 is a reply to message #205186] Tue, 28 November 2006 05:46 Go to previous messageGo to next message
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
Re: DATABASE LINK in Forms [message #206114 is a reply to message #205997] Tue, 28 November 2006 17:44 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: DATABASE LINK in Forms [message #206189 is a reply to message #206114] Wed, 29 November 2006 02:07 Go to previous messageGo to next message
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
Re: DATABASE LINK in Forms [message #206279 is a reply to message #206189] Wed, 29 November 2006 07:29 Go to previous messageGo to next message
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
Re: DATABASE LINK in Forms [message #206384 is a reply to message #206279] Wed, 29 November 2006 18:27 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: one side oval shaped push button
Next Topic: migration from 6i to 10gforms-alternate for d2kwutil.pll ?
Goto Forum:
  


Current Time: Thu Dec 08 04:20:03 CST 2016

Total time taken to generate the page: 0.05814 seconds