If you are using OracleAS Integration InterConnect 10.1.2.0.x:
  1. Select the Deploy tab and expand Applications
  2. Right-click your Application (e.g. DBApp) and select Deploy PL/SQL
  3. Expand to the Events and/or Procedures you want to deploy (IMPORTANT: You must select all InterConnect Events and Procedures for a given Business Object, because iStudio will actually replace the PL/SQL Package for that Business Object with a new PL/SQL Package containing only the PL/SQL Functions and Procedures to support your selected InterConnect Events and Procedures!)
  4. Click Next
  5. Database Information:
  6. Click Next, then Next, and then Deploy - you should see a "Successful" message
  7. Click Cancel (not very intuitive, I know)

If you are using OracleAS10g (9.0.4) InterConnect (or the above method fails because of object dependencies in the database (in which case you must manually remove the objects before running the script) or you want to be sure that no PL/SQL logic is accidentally removed, see above):

  1. If you are using 9.0.2 or 9.0.4, select File from the main menu, and then Export PL/SQL - otherwise, select the Deploy tab, right-click Applications, and select Export PL/SQL
  2. Select your Application (e.g. DBApp)
  3. In the File Prefix field, enter c:\
  4. Click OK
  5. Start SQL*Plus and connect as dbapp/dbapp@orcl
  6. Run the script(s) for the deployed Events and/or Procedure, e.g. _DBApp_Address.sql:
    start c:\_DBApp_Address.sql