Wish List - Linux version

Jim Stutz

Member
Novell is moving all employees to a Suse Linux desktop. Are there any plans to create a Linux version of PL SQL Developer?
 
I agree I would like to see a version that runs on Linux, or OS X. As soon as we more our development tools to Java my goal is to eliminate Windows
 
Hi,
There are not a lot of userfull PL/SQL Tools with linux ( Tora, ... )
So PL/SQL-Developer would have a chance to get to the most used PL/SQL Tools with Linux-support.

Orca
 
Could it be an (intermediate) option to get PLSQL Dev running within Wine? Anyone having experiences with that? PLSQL Dev should connect to Oracle@Linux.

I made some basic tests today and I could at least bring up the PLSQL UI with nologon command line option. Speed Button Icons where not visible (had a line saying 'fixme:commctrl:FlatSB_SetScrollProp stub' in stdout). I could not connect to Oracle nor load oci.dll (Oracle env/Registry not OK).
 
I tried running PL/SQL Developer again using WINE (and the Oracle Instant Client 10.2). I was encouraged by what I saw, so I was hoping that I could get some information on the following problems, in the hope that there is a workaround in the form of just copying some appropriate DLLs.

What I *was* able to do is start the program, use the connect dialog (which read my tnsnames.ora) to connect to a database, and use the Object Browser to see the User's packages and tables.

The main problem is that opening nearly any dialog or window causes PL/SQL Developer to catch an exception like the following:
Code:
Exception 'EReadError' in module plsqldev.exe at 00026857
Error reading ProcColEditor.Font.Height: Interface not supported
If there is an answer like "that's caused by the GetFoo() function in Win32GUIStuff.DLL", that would be helpful.

Secondly, the large icons (toolbar, "Define Browser Folders" dialog, etc.) don't load. The small ones ("Refresh data", "Folders..."), do. Going on the small amount of Win32-dev-knowledge I have, I'm assuming these icons are all stored as resources in the executable, and the large icons are simply in a format that WINE doesn't understand. However, it could also have something to do with the "Bitmap already selected in another DC" warnings that are generated.

If someone could shed a little light on this, that would be helpful as well.

I am interested to see PL/SQL Developer work on Linux, and WINE seems to take care of a very large chunk of the effort that would be involved. Given that tOra is painful to use and even harder to install, I'm guessing the upcoming Oracle Raptor will be the de-facto standard for PL/SQL development on Linux. However, as of right now, there are no Linux tools that come even close to PL/SQL Developer's quality and functionality.
 
As you may or may not know, PL/SQL Developer is written in Delphi. I did a quick search for a WINE problem with Delphi applications in general and Delphi/fonts&icon problems in particular, but did not find a common problem or solution.
 
I'll see what else I can find out.

I'm very encouraged by the fact that I was able to use the Object Browser without a problem. If my C-, Windows-, and Linux-coding skills were a little more advanced, I'd be all over finding the missing WINE pieces and implementing them. Unfortunately, as of right now, I'm running purely on curiosity.
 
I have been running PL/SQL Developer on the Novell Linux Desktop (NLD - SUSE Linux 9.1) platform for 20 months now.

NLD uses CrossOver Office which sits on top of WINE.

I copied the PL/SQL files from windows to linux.
I manually edited the linux system.reg file and added the PL/SQL registry items.
I changed the ./dotwine/config file so that
"Managed" = "N"

PL/SQL Developer works just like it does in Windows. There is a focus problem, which is resolved by making a selection from the Browser. Other than this minor inconvience it works great.
 
Thanks for that information Jim! I'll have to check out the CrossOver Office trial when I get a chance. That just leaves the question why PL/SQL Developer works in CrossOver Office, but not in WINE. But I'm sure that's a question for a different forum :)
 
Back
Top