Insight Developer - PL/SQL Editor,PL/SQL Profiler

Integrated Development Environment for Oracle Database! Get your FREE fully-functional evaluation copy here !

Online Document

AVI video : How to debug Stored procedure (click to download zip file)

AVI video : Debug trigger using anonymous pl\sql blocks (click to download zip file)

How to install Insight Developer on Linux

Currently Insight Developer only support two distribution methods under 32-bit Linux:

Debian package (.deb)
Generic Linux 32-bit binary

Debian package will install desktop entries, adding a menu entry to the KDE or GNOME menu in the Development or Programming group. For Generic Linux 32-bit binary, you need to setup it manually.

For Generic Linux 32-bit binary, Uncompress tarbar using below command:
$tar zxf insightdev.tar.gz

The Environmnet variable LD_LIBRARY_PATH must setup to the Oracle Library.
TNS_ADMIN and ORACLE_HOME variable also need to setup either one or both.

example for bash shell:
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

For Ubuntu, to execute Insight Developer from menu, you need to setup the varaible in /etc/environment. without the export. Sometime it doesn't work.
That is an artical from "Andrew Beacock's Blog" How to add shared libraries to Linux's system library path

Tester on:
Zenwalk 5.2, OpenSuse 10.3 and Ubuntu > 6.06 release.

Note: For Linux, without the Code Formating