How do I deploy PL/SQL code to use with the Database adapter?
The following steps describe how to deploy PL/SQL code for the Database adapter: • Click the Deploy tab in the iStudio window. • Right-click a Database application and select Deploy PL/SQL. The Deploy PL/SQL – Select Events/Procedures screen is displayed. • Select the application, event or procedure to deploy the corresponding PL/SQL. • Click Next. The Deploy PL/SQL – Database Information dialog box is displayed. This dialog box enables you to specify the database connection information for deploying the PL/SQL code. • Enter information in the following fields: Database username: The database user name required for connecting to the database. Database password: The password required for connecting to the database. Database URL: The URL of the database required for connecting to the database. The URL should be in the form: host:port:SID. • Click Next. The Deploy PL/SQL – Summary dialog box is displayed, which displays a summary of the database connectivity information entered in the pre
