Integrating Oracle SQL Developer or Oracle SQL*Plus with the Oracle Life Sciences Data Hub

To use Oracle SQL Developer or SQL*Plus as an IDE for Oracle LSH PL/SQL Programs, each Definer must do the following on his or her local PC:

• Install Oracle SQL Developer or SQL*Plus in the location specified by the system administrator.

• Install the Oracle LSH client plug-in by inserting the CD-ROM supplied by the system administrator. (See Install the Client Plug-In for details.)

• Ensure that cdrconfig.xml has the correct directory path for the Oracle SQL Developer (or SQL*Plus) executable.

  Note:

  If the Definer has both Oracle SQL Developer and SQL*Plus installed on the local computer, he or she can switch between the two IDEs by changing the executable directory path in cdrconfig.xml.

• Start Oracle SQL Developer or SQL*Plus and create a connection to the Oracle LSH database. The username and password for this connection must be those of an Oracle LSH database user account.

• Follow the steps in Set the NLS_LANG Environment Variable to UTF8.

• Install Winzip Pro 11.2 SR-1, Winzip 8.1, or any other Winzip that includes the WZUNZIP.exe

This section contains the following topic:

• Set the NLS_LANG Environment Variable to UTF8
  

Set the NLS_LANG Environment Variable to UTF8

To set an Oracle client application like SQL*Plus to use the right encoding, you must set the environment variables on the client machine to UTF8. The required settings vary, depending on the operating system.

• Windows
  
• UNIX
  

Windows

Check and set your NLS_LANG environment variable:

1. Right-click the My Computer icon on your desktop, then click Properties.

2. Click the Advanced tab, then click Environment Variables.

3. In User Variables and System Variables, check if there is a variable named NLS_LANG.

4. If there is an NLS_LANG variable, highlight it and click Edit.

5. Set the variable value to UTF8; for example: AMERICAN_AMERICA.UTF8

If you do not have the NLS_LANG environment variable, change your registry settings:

1. Click Start, then Run.
2. In the Run window, enter regedit and click OK.
3. Locate one of the following registry key entries:

   • HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE

   • HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEx

     where x is the unique number identifying the Oracle home

4. Add a new key named NLS_LANG with a value including UTF8; for example:

   NLS_LANG=AMERICAN_AMERICA.UTF8

UNIX

Do the following:

1. Check the environment variable NLS_LANG:

   echo $NLS_LANG
   

2. Set the environment variable NLS_LANG to UTF8; for example:

   % setenv NLS_LANG American_America.UTF8