Topic Options
#44474 - 08/26/12 11:03 PM Error message box with no message breaks PLSQL Dev
sjwales Offline
Member

Registered: 08/26/12
Posts: 3
Loc: 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


Edited by sjwales (08/26/12 11:05 PM)

Top
#44481 - 08/27/12 05:42 AM Re: Error message box with no message breaks PLSQL Dev [Re: sjwales]
Marco Kalter Administrator Offline
Member

Registered: 08/30/99
Posts: 16912
On Windows 7 you will need to use an Oracle11g Client.
_________________________
Marco Kalter
Allround Automations

Top
#44483 - 08/27/12 09:38 AM Re: Error message box with no message breaks PLSQL Dev [Re: Marco Kalter]
sjwales Offline
Member

Registered: 08/26/12
Posts: 3
Loc: 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 ?


Edited by sjwales (08/27/12 09:39 AM)

Top
#44484 - 08/28/12 04:30 AM Re: Error message box with no message breaks PLSQL Dev [Re: sjwales]
Dezsoe Kados Offline
Member

Registered: 12/01/05
Posts: 85
Loc: 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.

Top
#44485 - 08/28/12 08:57 AM Re: Error message box with no message breaks PLSQL Dev [Re: Dezsoe Kados]
sjwales Offline
Member

Registered: 08/26/12
Posts: 3
Loc: Salt Lake City, Utah, USA
Looks like running PLSD as Administrator solves the problem!

Top


Moderator:  support