Home » Developer & Programmer » Forms » ORA-12560 ........... How could it resolve ? (DATABASE 10g , FORMS 6i , FORMS 10g , WIN XP SP2)
icon1.gif  ORA-12560 ........... How could it resolve ? [message #331693] Fri, 04 July 2008 11:21 Go to next message
Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt
Senior Member

I installed both forms 6i , 10g ...... both work correctly , but just when I be in the beginning onto Run Time in forms 10g ... this error occur to me :-
http://img79.imageshack.us/img79/6555/ora12560dh4.png
and then I press OK and enter this information :-
http://img91.imageshack.us/img91/9980/ora12560nextstepek2.png
and when I press connect , i enter to form correct without any other problems.

I ask for help about the cause of that Problem (ORA-12560) , and also the Solution for it Question Exclamation Exclamation Exclamation
Re: ORA-12560 ........... How could it resolve ? [message #331698 is a reply to message #331693] Fri, 04 July 2008 12:30 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
First thing I can think of is that you have a different database-descriptor you default try to connect to (i.e. not orcl)
icon2.gif  Re: ORA-12560 ........... How could it resolve ? [message #332039 is a reply to message #331693] Mon, 07 July 2008 05:33 Go to previous messageGo to next message
debashispattanayak
Messages: 5
Registered: July 2008
Location: Bhubaneswar
Junior Member

Before running or compiling form make sure that u have loged in to the database using connect descriptor/host string (like username:SCOTT password:TIGER hoststring:ORCL)or if u are calling that form through menu then in the ON-LOGON trigger u try the followig:-

'SCOTT'||'/'||'TIGER'||'@'||'ORCL'
or
check wheather u have configured the tnsnames.ora file in the network folder for both 6i and 10g

[Updated on: Mon, 07 July 2008 05:42]

Report message to a moderator

icon2.gif  Re: ORA-12560 ........... How could it resolve ? [message #333210 is a reply to message #331693] Thu, 10 July 2008 18:32 Go to previous message
Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt
Senior Member

at Form Level , ON-LOGON :-
logon('scott','Tiger@orcl');

that's all , the problem solved Smile
Previous Topic: Calculation without Summary Column
Next Topic: how to use array variable
Goto Forum:
  


Current Time: Thu Dec 08 16:03:43 CST 2016

Total time taken to generate the page: 0.05239 seconds