If you are using OracleAS Integration InterConnect 10.1.2.0.x:
- Select the Deploy tab and expand Applications
- Right-click your Application (e.g. DBApp) and select Deploy PL/SQL
- 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!)
- Click Next
- Database Information:
- As Database username, enter dbapp
- As Database password, enter dbapp
- As Database URL, enter donald.disney.com:1521:orcl (already filled in)
- Click Next, then Next, and then Deploy - you should see a "Successful" message
- 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):
- 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
- Select your Application (e.g. DBApp)
- In the File Prefix field, enter c:\
- Click OK
- Start SQL*Plus and connect as dbapp/dbapp@orcl
- Run the script(s) for the deployed Events and/or Procedure, e.g. _DBApp_Address.sql:
start c:\_DBApp_Address.sql