Print Thread
Error message box with no message breaks PLSQL Dev
#44474 08/27/12 03:03 AM
Joined: Aug 2012
Posts: 3
Salt Lake City, Utah, USA
S
sjwales Offline OP
Member
OP Offline
Member
S
Joined: Aug 2012
Posts: 3
Salt Lake City, Utah, USA
Here's the setup:

Oracle 10g client on Windows 7 32 bit
Latest version of PLSQLDEV (just updated).

Tried connecting to 11g database on Windows. Worked fine.
Tried connecting to 8i database on HPUX - I get an error dialog box comes up, title to the box just says "PL/SQL Developer", no text in the box, just an OK button.

Click it, the status of the session is "Not logged in".

However, now it won't login to *anything*.

No matter what, I always get the white box with no message.

If I try to use the Session menu and login, same thing happens but message box header says "(Not logged on)".

Anyway I can (a) get this fixed and (b) connect to the 8i database successfully.

I use this software often and having it not working is a pain.

Thanks
Steve

Last edited by sjwales; 08/27/12 03:05 AM.
Re: Error message box with no message breaks PLSQL Dev
sjwales #44481 08/27/12 09:42 AM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
On Windows 7 you will need to use an Oracle11g Client.


Marco Kalter
Allround Automations
Re: Error message box with no message breaks PLSQL Dev
Marco Kalter #44483 08/27/12 01:38 PM
Joined: Aug 2012
Posts: 3
Salt Lake City, Utah, USA
S
sjwales Offline OP
Member
OP Offline
Member
S
Joined: Aug 2012
Posts: 3
Salt Lake City, Utah, USA
The 11g client is incompatible with 8i database and I really need to generate the code for dozens of stored procedures and functions from the 8i database.

Manually putting the code back together from dba_source wasn't exactly my plan, but I can do it if I have to.

The 10g client did work against an 11g database until I tried to connect to the 8i - then it doesn't work for anything any more.

Is there any way to make it work ?

Last edited by sjwales; 08/27/12 01:39 PM.
Re: Error message box with no message breaks PLSQL Dev
sjwales #44484 08/28/12 08:30 AM
Joined: Dec 2005
Posts: 132
Leoben,Austria
D
Member
Offline
Member
D
Joined: Dec 2005
Posts: 132
Leoben,Austria
Seems to me, that PLSD is not using in your case the 10g client, but the 11g version. Have you tried in PLSD to enforce the Oracle 10g Home in "Setting/Oracle/Connection/Oracle Home"?
This works at least for me in W7 (I have three different clients 9/10/11 installed so that I can select the "correct" one)
Btw. the "incompatibilty" 11g client/8i database is some standard Oracle behaviour.

Re: Error message box with no message breaks PLSQL Dev
Dezsoe Kados #44485 08/28/12 12:57 PM
Joined: Aug 2012
Posts: 3
Salt Lake City, Utah, USA
S
sjwales Offline OP
Member
OP Offline
Member
S
Joined: Aug 2012
Posts: 3
Salt Lake City, Utah, USA
Looks like running PLSD as Administrator solves the problem!


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.030s Queries: 15 (0.007s) Memory: 2.5150 MB (Peak: 3.0397 MB) Data Comp: Off Server Time: 2024-03-28 13:56:12 UTC
Valid HTML 5 and Valid CSS