Launching Oracle SQL Developer

When you click Launch IDE from an Oracle Life Sciences Data Hub PL/SQL Program, the following takes place:

• If yourOracle LSH PL/SQL Program contains a Source Code instance with a PL/SQL package in it, then Oracle LSH compiles your PL/SQL package.

  Note:

  If there are any bugs in your PL/SQL package, Oracle SQL Developer fails to launch and an error message related to the bug appears on the Oracle LSH screen.
• Oracle LSH launches Oracle SQL Developer. Connect to the Oracle LSH database using your database user credentials.

  Note:

  If you cannot find an Oracle LSH database connection to which you can connect, you may have to set up the connection. Contact your System Administrator for more information.
• Table instances mapped to your Program's source Table Descriptors appear as synonyms in Oracle SQL Developer; for example, if the Oracle Name of a source Table descriptor is DEMOG then there will be a synonym by the name DEMOG in Oracle SQL Developer.
• Table instances mapped to your Program's target Table Descriptors appear as empty tables in Oracle SQL Developer.

  You can edit, compile, and execute your PL/SQL package in Oracle SQL Developer and these tables reflect the results of your data manipulation. However, the data is not written to Oracle LSH Table instances.

  Note:

  If you do not want to lose changes you made to the PL/SQL package in Oracle SQL Developer, you must upload your package back into the Oracle LSH PL/SQL Program's Source Code instance before you exit Oracle SQL Developer. See Modifying Source Code for instructions.