I am trying to compile a package that contains ampersands within the code. Is there a toggle box in 'Preferences' that allows me to turn this off (set define off)?...Or...do I have to compile my package in a command window and use the 'Set define off' command?
Thanks in advance.
Thank you Stian,
I believe you are correct. I uninstalled the 64bit Oracle 11g client, and reinstalled the 32bit client. Then I reinstalled PL/SQL Developer outside the "Program Files (x86)" directory. Now, Developer sees the tnsnames file and connects to the external databases with no problem...
I've installed the Oracle 64bit 11g client, and then installed PL/SQL Developer in C:/PLSQL Developer folder (not in the C:/Program Files (x86) folder). Several tnspings prove that the alias connections are good. The Oracle_Home directory is correct in the registry, and I set it in PL/SQL...
I was searching your other support threads, and I believe I found the solution.
I am also using a 64bit WIndows XP with the C:\Program Files (x86) directory....
I will install the 11g client (and then SQL Developer again) and see if that fixes my "ora-12154" problem.
Thank you for the previous...
I just installed PL/SQL Developer 5.1.6.747 on top of XP sp3 and I'm receiving the "ora-12154: TNS:could not resolve the connect identifier specified". I can ping all of my databases within my tnsnames.ora folder, so I don't understand the reason for this error message. Please help.