Setting Up Oracle SQL Developer or SQL*Plus as an IDE

To use either Oracle SQL Developer or SQL*Plus to edit and compile your Oracle Life Sciences Data Hub PL/SQL Programs, do the following on your local PC:

• Get the CD-ROM that contains the files cdrconfig.xml and cdrclient.exe from your system administrator and insert it into your PC. InstallShield automatically runs setup.exe, that loads cdrconfig.xml and cdrclient.exe to a location you specify on your local computer.
• Ensure that cdrconfig.xml has the correct directory path for the Oracle SQL Developer or SQL*Plus executable.

• Launching Oracle SQL Developer
  When you click Launch IDE from an Oracle Life Sciences Data Hub PL/SQL Program, the following takes place:
• Relaunching Oracle SQL Developer from within Oracle Life Sciences Data Hub
  
• Relaunching Oracle SQL Developer from outside Oracle Life Sciences Data Hub
  If you log in to Oracle SQL Developer from outside Oracle LSH, you do not get access to the source tables but you can edit the PL/SQL package.