Skip Headers
Oracle® Cloud Using Oracle Database Cloud Service
Release 12.2

Part Number E27038-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

4 Developing Applications for Oracle Database Cloud Service

This section describes everything an Oracle Database Cloud Service (Database Cloud Service) user needs to know to perform the following:

Topics:

Launching a Database Cloud Service

To launch a Database Cloud Service:

  1. From the Oracle Cloud home page, go to the My Services page. See "Accessing the My Services Page".

    The My Services home page appears.

  2. Next to the Database Cloud Service, click the Launch Service icon.

    The Oracle Application Express home page displays.

    Description of apex_home.gif follows
    Description of the illustration apex_home.gif

Importing Data

Several methods are available for uploading data into the database. For an initial data upload on the Oracle Cloud, use Oracle SQL Developer, the Application Express SQL Workshop Data Upload Utility or the Application Express Data Load utility.

The following sections describe the various methods used to load your Cloud Database service with data.

See Also:

For instructions on using RESTful Services to access data, see "Implementing RESTful Web Services".

Topics:

Using SQL Developer for Data Loading

Oracle SQL Developer, in conjunction with your Database Cloud Service SFTP server, provides the ability to upload data to your Database Cloud Service. SQL Developer is used to create a cart containing objects you want to load into your Database Cloud Service, connect to your Database Cloud Service and deploy, also referred to as load, data from the cart to the service.

To deploy objects to your service you must perform the following steps:

  1. Create or use an existing Database Cloud Service. See "Creating or Using an Existing Database Cloud Service for Data Loading".

  2. Install SQL Developer locally. This application is used to create the cart of objects to load and to perform the deploying of data from the cart to the service. See "Installing SQL Developer".

  3. Add a Cloud connection from SQL Developer to your Database Cloud Service. See "Configuring SQL Developer Cloud Connection".

  4. Reset the SFTP account user password. See "Setting Up Secure FTP Account".

  5. Using SQL Developer, create a cart filled with objects and deploy to the Database Cloud Service. See "Creating and Deploying a Cart of Objects".

  6. Configure the Database Cloud Service to allow access to the service from additional SQL Developer users. See "Creating Additional Users for SQL Developer".

Topics:

Creating or Using an Existing Database Cloud Service for Data Loading

The first step in the data loading process is to locate the Welcome to Oracle Cloud email received during the Database Cloud Service creation process. If the Database Cloud Service does not yet exist, see "Starting Trial Services" in Getting Started with Oracle Cloud.

During the service creation process and after your service has been activated, a Welcome to Oracle Cloud email is sent. This email contains important usernames and URLs required for configuring SQL Developer and the Secure FTP site for data loading. See "Configuring SQL Developer Cloud Connection" and "Setting Up Secure FTP Account".

Note:

Save the Welcome to Oracle Cloud email for the Database Cloud Service you are loading with data. This email contains information required for the data loading configuration process.

Installing SQL Developer

The SQL Developer is used to create carts of data structures, DDLs, and data to deploy to the Database Cloud Service. This section describes how to install SQL Developer.

Note:

The Cloud functionality described here requires the SQL Developer Release 3.2 or later.

To install SQL Developer locally:

  1. From the Oracle Cloud home page, go to the My Services page. See "Accessing the My Services Page".

    The My Services home page appears.

  2. Select a Database Cloud Service.

    The Overview page displays.

  3. Select the Resources tab.

    The Resources page displays.

    Description of downloads.gif follows
    Description of the illustration downloads.gif

  4. Click Oracle Cloud Downloads link.

    The Oracle Cloud Downloads page appears.

  5. Click the SQL Developer link.

  6. Download Oracle SQL Developer.

  7. Unzip the contents to a local folder.

  8. To start SQL Developer, run sqldeveloper.exe.

    Note:

    If your machine is 64 bit, you may need to run the sqldeveloper.bat file instead.

Note:

You must install JDE run time if you do not have JDE runtime installed. For installation and setup instructions, see SQL Developer documentation on the Oracle Technology Network at: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

Configuring SQL Developer Cloud Connection

SQL Developer must have a Cloud connection configured to connect to the Database Cloud Service. The connection can use the default username and password provided for Database Cloud Service. Additional users can access the service through SQL Developer if they are given the Developer role in the IDM Console. See Configuring user roles in IDM documentation.

SQL Developer users can also be added through Application Express using the steps outlined in "Creating Additional Users for SQL Developer".

To add a Cloud connection:

  1. Launch SQL Developer locally.

    The SQL Developer home page displays.

    Description of sql_dev.gif follows
    Description of the illustration sql_dev.gif

  2. Under Connections, right click on Cloud Connections.

    The Cloud Connection menu appears.

    Description of sl_dev_connect.gif follows
    Description of the illustration sl_dev_connect.gif

  3. Select New Cloud Connection.

    The New Cloud Connection dialog appears.

    Description of empty_conn.gif follows
    Description of the illustration empty_conn.gif

  4. Locate the Welcome to Oracle Cloud email you received when this Oracle Database Cloud Service was activated. The following information from the email under Service Details is required to configure the New Cloud Connection:

    • Service Home - The Database Cloud service URL.

    • User - The SFTP user for this Database Cloud Service.

    • Secure FTP Site - The SFTP site URL.

    Description of email.gif follows
    Description of the illustration email.gif

  5. Make the following entries:

    • Connection Name - Enter the name for this cloud connection.

    Database

    SFTP

    • Username - Enter the User from the Welcome to Oracle Cloud email under Service Details.

    • Hostname - Enter the Secure FTP Site from the Welcome to Oracle Cloud email under Service Details.

    • Port - Enter 22.

    Description of new_conn.gif follows
    Description of the illustration new_conn.gif

  6. Click OK.

  7. Under Cloud Connections on SQL Developer, open the new cloud connection.

    The Authentication dialog appears.

  8. Enter the Password required during sign in when launching the Database Cloud Service. See "Starting Trial Services" in Getting Started with Oracle Cloud.

    If you have connected successfully the tables and other objects from the Database Cloud Service will display under Cloud Connections.

    Description of sqldev_tbls.gif follows
    Description of the illustration sqldev_tbls.gif

Setting Up Secure FTP Account

The Secure FTP user password must be reset before you can deploy a data upload. To do this you log into the IDM Console for your Database Cloud Service, find the FTP username and reset the password. The SFTP username is included in the Welcome to Oracle Cloud email received during the activation process.

Note:

The Service SFTP user from the Welcome to Oracle Cloud email must be used to access the data uploads. The Domain SFTP user will not see the data upload files.

To reset the Secure FTP username:

  1. Got to the Oracle Cloud My Services page. See "Accessing the My Services Page".

    The My Services home page appears.

    Description of idm_button.gif follows
    Description of the illustration idm_button.gif

  2. Click Identity Console.

    The Identity Console login page appears.

  3. If prompted to log in, enter the Database Cloud Service sign in credentials and click Sign In

    The Identity Console home page appears.

  4. Click Sign in.

    The Identity Console appears.

  5. On the left panel, click Manage Users.

    The Search Users page appears.

  6. To view the list of users, click Search.

  7. Locate the Secure FTP user included in the Welcome to Oracle Cloud email.

    Description of ftp_user.gif follows
    Description of the illustration ftp_user.gif

  8. Locate and select the Secure FTP user in the Identity Console list of users.

    Description of idm_ftp_user.gif follows
    Description of the illustration idm_ftp_user.gif

  9. Click Reset Password.

    The Reset Password dialog displays.

    Description of reset_psw.gif follows
    Description of the illustration reset_psw.gif

  10. Click Manually change the password.

  11. For New password, enter the new password.

  12. For Confirm new password, enter the new password.

  13. Click Reset Password.

    Confirmation dialog appears.

  14. Click OK.

Creating and Deploying a Cart of Objects

To create and deploy a cart of objects to a Database Cloud Service:

  1. From SQL Developer, click View.

    The View drop down menu displays.

    Description of view_cart.gif follows
    Description of the illustration view_cart.gif

  2. From the drop down menu, click Cart.

    The Cart window appears on the bottom right.

    Description of empty_cart.gif follows
    Description of the illustration empty_cart.gif

  3. From the left panel, drag the Oracle Database objects you want to load and drop them into the Cart window on the right.

    Description of full_cart.gif follows
    Description of the illustration full_cart.gif

  4. If you want to include data with the cart deployment, in the Cart window, click the Data check box.

  5. To deploy this cart, click the Deploy Cloud icon at the top left of the Cart window.

    Description of deploy_icon.gif follows
    Description of the illustration deploy_icon.gif

    The Deploy Objects To Cloud dialog displays.

  6. For the Deploy Objects To Cloud dialog, make these changes:

    Under Cloud:

    These options supply information required to connect to the Secure FTP server.

    • Connection - Select the cloud connection for the Database Cloud Service you are deploying to.

    • Title - Enter a title for this deployment. The title is restricted to 15 characters long and alphanumeric characters (a-z, A-Z, 0-9), _ (underscore) and - (dash). No special characters, such as spaces, are allowed.

    • Server - Enter the Secure FTP URL from the Welcome to Oracle Cloud email.

    • Port - Leave as default of 22.

    • SFTP User - Enter the Secure FTP username. See "Setting Up Secure FTP Account".

    • SFTP Password - Enter the Secure FTP user's password. See "Setting Up Secure FTP Account".

    Under Transfer:

    This option specifies the cart that is deployed.

    • File - Enter or browse for the file you want to deploy. This file is a zip file generated by SQL Developer and contains all objects and optionally data included in the cart.

    Under Deploy DDL:

    These options determine if the DDL will replace exisitng objects.

    • Do not replace existing destination objects - Creates objects in the destination schema only if objects do not already exist.

    • Replace existing destination objects - Drops existing objects in destination schema if they already exist then creates and optionally loads them.

    Under Deploy Data:

    These options determine how the data is deployed to the destination Database Cloud Service.

    • Truncate destination data - Select this option to truncate existing tables before adding rows.

    • Disable constraints before moving data - Select this option to disable all constraints before moving the data. Re-enables the constraints after the data has been moved.

    • Delimiter - Leave as the default.

    • Line Terminator - Leave as the default.

    • Left Enclosure - Leave as the default.

    • Right Enclosure - Leave as the default.

    Description of deployment.gif follows
    Description of the illustration deployment.gif

  7. Click Apply.

    The Exporting dialog displays.

    Description of exporting.gif follows
    Description of the illustration exporting.gif

Checking Deployment Status

To check on deployment status:

  1. From SQL Developer, under Cloud Connections, open a cloud connection.

  2. Under the open cloud connection on left panel, click Deployments.

    The list of deployments displays.

  3. Under Deployments, click on a deployment.

    The deployment DETAILS tab displays at the top right.

    Description of approved.gif follows
    Description of the illustration approved.gif

  4. The status value on the DETAILS page indicates the progress of the deployment.

    • APPROVED - The deployment passed a virus scan and is waiting for processing.

    • PROCESSING - A background daemon process that is scheduled to run periodically, found the APPROVED deployment, changed the status to PROCESSING and started the SQL*loader jobs.

    • PROCESSED - The deployment completed successfully.

    • DENIED - The deployment is not approved.

  5. To view deployment results, click LOGS.

    The LOGS tab displays.

    Description of logs.gif follows
    Description of the illustration logs.gif

  6. To see the latest uploaded tables, on the Connections panel, click the Refresh icon.

    Description of refresh.gif follows
    Description of the illustration refresh.gif

    Note:

    If the Refresh button is not available, the cloud connection is not connected.
  7. From the SQL Workshop Object browser for your Database Cloud Service, view the progress of the data upload and verify that objects and optionally data has uploaded correctly.

SQL Developer for Data Loading into the Database Cloud Service uses the database utility SQL*Loader to perform the data load. To find out more about restrictions on data loading, see the Oracle Database Utilities book.

Restarting a Deployment

To restart a deployment:

  1. From SQL Developer, click Cloud Connections.

  2. Click the cloud connection.

  3. Click Deployments.

    The list of deployments displays.

  4. Right click the deployment.

    Menu options appear.

    Description of restart_logs.gif follows
    Description of the illustration restart_logs.gif

  5. From the menu options, select Restart.

  6. Follow on-screen instructions.

Removing a Deployment

To remove a deployment:

  1. From SQL Developer, click Cloud Connections.

  2. Click the cloud connection.

  3. Click Deployments.

    The list of deployments displays.

  4. Right click the deployment.

    Menu options appear.

    Description of delete_logs.gif follows
    Description of the illustration delete_logs.gif

  5. From the menu options, select Delete.

  6. Follow on-screen instructions.

Clearing Logs

To clear the log for a deployment:

  1. From SQL Developer, click Cloud Connections.

  2. Click the cloud connection.

  3. Click Deployments.

    The list of deployments displays.

  4. Right click the deployment.

    Menu options appear.

    Description of clear_logs.gif follows
    Description of the illustration clear_logs.gif

  5. From the menu options, select Clear Logs.

  6. Follow on-screen instructions.

Creating Additional Users for SQL Developer

SQL Developer users can also be added through Application Express.

To configure an Oracle Database Cloud Service for Data Loading:

  1. Launch the Database Cloud Service. See "Launching a Database Cloud Service".

    The Oracle Application Express home page appears.

    Description of administration.gif follows
    Description of the illustration administration.gif

  2. From the Application Express Builder, click Administration.

    The Administration home page displays.

    Description of manage_users.gif follows
    Description of the illustration manage_users.gif

  3. Click Manage Users and Groups.

    The Manage Users and Groups page appears.

    Description of create_users.gif follows
    Description of the illustration create_users.gif

  4. Click Create User.

    The Create User page appears.

  5. Enter user information. See "Managing Application Express Users" in the Oracle Application Express Administration Guide.

  6. Under Password, for Require Change of Password on First User select No.

    Description of password.gif follows
    Description of the illustration password.gif

  7. Under User Groups (For authentication against Application Express user account repository only), select at least SQL Developer.

    Description of user_group.gif follows
    Description of the illustration user_group.gif

  8. Click Create User.

Using SQL Workshop Data Upload Utility

The Data Upload utility enables you to upload data from a text file, an XML document or a spreadsheet. The utility is accessed from the Application Express SQL Workshop.

To upload data using the Data Upload utility:

  1. Launch the Database Cloud Service. See "Launching a Database Cloud Service".

    The Oracle Application Express home page displays.

  2. Click SQL Workshop.

  3. Click Utilities.

  4. Click Data Workshop.

  5. Click one of the following types of data:

    • Text Data

    • XML Data

    • Spreadsheet Data

  6. Follow on-screen instructions.

To learn more about uploading data with the Data Upload utility, see "Using the Data Workshop to Manage Data" in the Oracle Application Express SQL Workshop Guide.

Using Application Express Application Data Load Utility

Applications with data loading capability allow application end users to dynamically import data into a table within any schema to which the user has access. To do this, end users run a Data Load Wizard that uploads data from a file or copies and pastes data entered by the end user directly into the wizard.

To learn more about developing Application Express applications with this capability, see "Creating Applications with Data Loading Capability" in the Oracle Application Express Application Builder User's Guide.

To learn more about how an application end user uses this capability, see "About Uploading Data" in the Oracle Application Express End User Guide.

Managing Data

The SQL Workshop Object Browser enables developers to browse, create, and edit objects in a database. Oracle Application Express has many views defined to make it easier for you to work with the underlying table structures. The views combine multiple base tables and use meaningful column names to minimize complexity and to be more intuitive to use. See Oracle Application Express API Reference for details of the views defined.

To manage data using Object Browser:

  1. Launch the Database Cloud Service. See "Launching a Database Cloud Service".

    The Oracle Application Express home page displays.

  2. Click SQL Workshop.

  3. Click Object Browser.

  4. Browse, create, edit and delete database objects.

    To learn more, see "Managing Database Objects with Object Browser" in the Oracle Application Express SQL Workshop Guide.

Exporting Data

You can create an Oracle Data Pump export of your data and data structure. Export files are downloadable from your secure FTP download area in the outgoing directory. Files are retained for 48 hours. To initiate a download, click the file names using your SFTP client.

Topics:

Creating an Oracle Data Pump Export

To create an Oracle data pump export of your data, code and data structure:

  1. From the Oracle Cloud home page, go to the My Services page. See "Accessing the My Services Page".

    The My Services home page appears.

  2. Select a Database Cloud Service.

    The Overview page displays.

  3. Click the Data Export tab.

    The Export Data page displays.

    Description of data_export.gif follows
    Description of the illustration data_export.gif

  4. Click Export Data.

    The Data Export page for your service displays.

  5. To include data with the data structures, select Include Data.

    Description of data_exp_data.gif follows
    Description of the illustration data_exp_data.gif

    Note:

    The Oracle Cloud accepts a maximum of 10 data export requests. If you want to create a data export request and you have already reached the maximum, you must delete an old request or wait 7 days for the data export to expire and be purged.
  6. Click Create Data Export.

    The Export Data page displays and lists the requested data export job.

    Description of data_exp_start.gif follows
    Description of the illustration data_exp_start.gif

  7. To initiate a download using the Secure FTP client, wait until the status is completed then click the file name.

    Tip:

    Click Refresh to update the data export status.

Downloading a Data Export

After creating a data export file, see "Creating an Oracle Data Pump Export", and the data export file has a status of completed, you can download the file.

To download a data export:

  1. Locate the Welcome to Oracle Cloud email you received when this Oracle Database Cloud Service was activated. Find your SFTP Account Details included in the email.

    Description of ftp_account.gif follows
    Description of the illustration ftp_account.gif

    Note:

    Your SFTP account password must have been reset at least once since the service was activated.

    Note:

    The Service SFTP user from the Welcome to Oracle Cloud email must be used to access the downloads. The Domain SFTP user will not see the data export files.
  2. Make sure you have some SFTP client software installed and setup to use for the download. The are examples of SFTP client software:

  3. For your SFTP client software, create a new connection or SFTP site. You need the host name, username and password. When using FileZilla, enter information then click Connect.

    The following screenshot shows using FileZilla Site Manager to do this.

    Description of site_mgr.gif follows
    Description of the illustration site_mgr.gif

  4. Once connected, you see two folders:

    • upload - this folder is where the SQL Developer Cloud Deployments arrive

    • download - this folder is where the Data Exports are delivered

    Description of folders.gif follows
    Description of the illustration folders.gif

  5. Double click the download folder.

  6. Select the file in the folder to download.

    Description of start_download.gif follows
    Description of the illustration start_download.gif

Cancelling a Data Export Request

To cancel a data export request:

  1. From the Oracle Cloud home page, go to the My Services page. See "Accessing the My Services Page".

    The My Services home page appears.

  2. Select a Database Cloud Service.

    The Overview page displays.

  3. Click the Data Export tab.

    The Export Data page displays.

  4. Click the export request you want to cancel.

    The Manage Data Export Request page displays.

  5. Select Confirm Cancel Request.

  6. Click Cancel Data Export Request.

Managing Oracle Application Express Database Applications

Database applications are managed with the Application Express Application Builder. The Application Express Application Builder allows you to create, edit and remove applications.

Topics:

Creating a Database Application

The Create Wizard allows you to create a complete application containing multiple pages including reports, interactive reports, forms, tabular forms, and master detail forms. The Create Application Wizard is designed to easily and quickly create Oracle Application Express Database applications.

Follow these steps to create a Database application:

  1. Launch the Database Cloud Service. See "Launching a Database Cloud Service".

    The Oracle Application Express home page displays.

  2. Click Application Builder.

    The Oracle Application Express Application Builder home page displays.

  3. Click Create.

    The first page of the Create Application wizard displays.

  4. Select Database and click Next.

  5. Follow on-screen instructions.

To learn more about creating Database applications, see "About Database Applications" in the Oracle Application Express Application Builder User's Guide.

To learn about using Database applications, see the Oracle Application Express End User Guide.

Modifying a Database Application

To modify a Database application:

  1. Launch the Database Cloud Service. See "Launching a Database Cloud Service".

    The Oracle Application Express home page displays.

  2. Click Application Builder.

    The Oracle Application Express Application Builder home page displays.

  3. Click the Database application you want to modify.

    The Application Edit page appears.

  4. Make modifications.

To learn more about modifying Database applications, see "About Database Applications" in the Oracle Application Express Application Builder User's Guide.

To learn about using Database applications, see the Oracle Application Express End User Guide.

Removing a Database Application

To remove a Database application:

  1. Launch the Database Cloud Service. See "Launching a Database Cloud Service".

    The Oracle Application Express home page displays.

  2. Click Application Builder.

    The Oracle Application Express Application Builder home page displays.

  3. Click the Database application you want to remove.

  4. Under Tasks on the right panel, click Delete this Application.

  5. Follow on-screen instructions.

To learn more about removing Database applications, see "About Database Applications" in the Oracle Application Express Application Builder User's Guide.

To learn about using Database applications, see the Oracle Application Express End User Guide.

Managing Oracle Application Express Websheet Applications

Websheet applications are created from the Application Express Application Builder. Websheets are applications designed to be created and modified by business users, with no knowledge of SQL necessary. A Websheet is like a wiki, except that Websheets can be driven by data included in the application. These applications are highly dynamic and defined by their users. Websheet applications include navigation controls, search capabilities, and the ability to add annotations such as files, notes, and tags. Websheet applications can be secured using access control lists and several built-in authentication models.

Topics:

Creating Websheet Database Objects

Before creating a Websheet application, required database objects must be created. This section describes how to create the required objects.

To create required Websheet database objects:

  1. Launch the Database Cloud Service. See "Launching a Database Cloud Service".

  2. Click Administration.

  3. Under Tasks on the right panel, click Websheet Database Objects.

    The Websheet Database Objects page appears.

  4. Click Create Websheet Database Objects.

    The required schemas and objects display.

  5. Click Continue.

  6. To confirm, click Create.

To learn more, see "Managing Websheet Database Objects" in Oracle Application Express Administration Guide.

Creating a Websheet Application

Before creating a Websheet, required Websheet database objects must exist. See "Creating Websheet Database Objects".

To create a Websheet application:

  1. Launch the Database Cloud Service. See "Launching a Database Cloud Service".

  2. Click Application Builder.

    The Oracle Application Express Application Builder home page displays.

  3. Click Create.

    This first page of the Create Application wizard displays.

  4. Select Websheet and click Next.

    The Create Websheet page appears.

  5. For Authentication, select one of the following:

  6. Click Create Websheet.

  7. To test the Websheet, click Run Websheet.

To learn more about modifying Websheet applications, see "About Websheet Applications" in the Oracle Application Express Application Builder User's Guide.

To learn about using Websheet applications, see "Using Websheets" in the Oracle Application Express End User Guide.

Modifying a Websheet Application

To modify a Websheet application:

  1. Launch the Database Cloud Service. See "Launching a Database Cloud Service".

    The Oracle Application Express home page displays.

  2. Click Application Builder.

    The Oracle Application Express Application Builder home page displays.

  3. Click the websheet you want to modify.

    The websheet Run or Edit Application page appears.

  4. Click Edit Properties.

To learn more about creating Websheet applications, see "About Websheet Applications" in the Oracle Application Express Application Builder User's Guide.

To learn about using Websheet applications, see "Using Websheets" in the Oracle Application Express End User Guide.

Removing a Websheet Application

To remove a Websheet application:

  1. Launch the Database Cloud Service. See "Launching a Database Cloud Service".

    The Oracle Application Express home page displays.

  2. Click Application Builder.

    The Oracle Application Express Application Builder home page displays.

  3. Click the websheet you want to remove.

    The websheet Run or Edit Application page appears.

  4. Click Edit Properties.

    The Application Properties page appears.

  5. Click Delete.

    The Confirm Delete page appears.

  6. Click Permanently Delete Now.

To learn more about creating Websheet applications, see "About Websheet Applications" in the Oracle Application Express Application Builder User's Guide.

To learn about using Websheet applications, see "Using Websheets" in the Oracle Application Express End User Guide.

Managing Oracle Application Express Packaged Applications or Sample Code

You can install Oracle Application Express packaged applications and sample code.

Topics:

Installing Packaged Applications and Sample Code

Follow these steps to install a packaged application or sample code:

  1. From the Oracle Cloud home page, go to the My Services page. See "Accessing the My Services Page".

    The My Services home page appears.

  2. Select a Database Cloud Service.

    The Overview page displays.

  3. Click the Applications tab.

    The Applications page displays.

  4. Click Install New.

    The Packaged Applications page displays showing all available packaged applications and sample code.

    Description of archive_app.gif follows
    Description of the illustration archive_app.gif

  5. Locate and click the packaged application or sample code you want to install.

    The application information page displays.

  6. Click Install Application.

  7. For Authentication, select one of the following:

  8. On the confirmation page, click Install Application.

  9. If you selected Application Express authentication, you will have the option of creating a first user for the application by entering the following information:

    • Create Application Express User - Select this option to create an application user before installation is complete. Otherwise, the user must be created after installation is complete using the Application Express Administration.

    • Username - Enter the username used to log in to the application.

    • Password -Enter the password used to log in to the application.

    • Confirm Password - Enter the same password again to confirm.

    • Email - Enter user's valid email address.

  10. If you selected Oracle Cloud Identity Management, the users currently authorized by Oracle Cloud Identity Management have access to this application. Use the Oracle Cloud Identity Console to add users. See "Managing Service Users" in Getting Started with Oracle Cloud.

  11. Click Run Application.

Modifying Sample Code

After installing sample code, it can be modified just like any other Database or Websheet application you have created from scratch or imported. See "Modifying a Database Application" and "Modifying a Websheet Application".

Note:

Installed sample code can be modified. Installed packaged applications can not be modified.

Removing Packaged Applications and Sample Code

Follow these steps to remove a packaged application or sample code:

  1. From the Oracle Cloud home page, go to the My Services page. See "Accessing the My Services Page".

    The My Services home page appears.

  2. Select a Database Cloud Service.

    The Overview page displays.

  3. Click the Applications tab.

    The Applications page displays.

  4. Next to the packaged application or sample code you want to remove, click Manage.

    The Packaged Application or Sample Code information page displays.

  5. Locate and click the packaged application or sample code you want to install.

    The application information page displays.

  6. Click Remove Application.

  7. To confirm, click Remove Application.

Managing Application Express Application End Users

Service administrators add and manage users of Oracle Application Express applications from the Oracle Identity Console or Oracle Application Express Administration. During application creation or installation, the method for managing users is defined.

Managing Application Security

Below are some topics that describe how to implement security best practices for Oracle Application Express and Oracle Cloud Database Service. Administrators are primarily responsible for ensuring the security of the Oracle Application Express setup, while developers are responsible for building secure applications.

To learn more, see "Managing Application Security" in Oracle Application Express Application Builder User's Guide.

Using Application Express Applications and Websheets

Once an application has been created or installed to an Oracle Database Cloud Service instance, end users with the appropriate authorization and authentication credentials can access it using a Web browser. The application administrator simply provides the end users with the application's URL.

The following URL shows the URL an application end user would use to access an Application Express application 100082 residing within an Oracle Database Cloud Service with an identity domain of trialaejm:

database-trialaejm.cloud.oracle.com/apex/f?p=100082

To learn more about using Database and Websheet applications, see the Oracle Application Express End User Guide.

Sending Emails

You can use the APEX_MAIL package to send an email from an Oracle Application Express application. APEX_MAIL contains three procedures. Use APEX_MAIL.SEND to send an outbound email message from your application. Use APEX_MAIL.PUSH_QUEUE to deliver mail messages stored in APEX_MAIL_QUEUE. Use APEX_MAIL.ADD_ATTACHMENT to send an outbound email message from your application as an attachment.

Example:

BEGIN
  APEX_Mail.Send( 'to@email-address.com', 'from@email-address.com', 
                  'This is some test plain text', 
                  'This is some test <b>HTML</b>', 
                  'Test Email Subject' );
  APEX_Mail.Push_Queue_Immediate;
END;
/

Note:

There is a built in limit of 5000 emails in any given 24 hour period. If you try to send more, you get an error.

To learn more, see APEX_MAIL in Oracle Application Express API Reference.

Scheduling Background and Asynchronous Jobs

Background jobs are scheduled by using the CLOUD_SCHEDULER package. Since the Database Cloud Service is a true multi-tenant environment, some aspects of the Oracle Database must be restricted to protect the integrity of both the data and the performance characteristics of the Database Cloud Service.

A Database Cloud Service cannot be allowed to have unlimited access to the creation and execution of jobs, as this would allow a single Service, either by accident or due to malicious intent, to overrun the underlying hardware resources. To address this, Database Cloud Service includes an interface which allows the limited use of database jobs.

This interface has the following characteristics:

The CLOUD_SCHEDULER package is a wrapper that exactly mirrors the DBMS_SCHEDULER package. The only difference between the packages is the CLOUD_SCHEDULER includes a simple procedure for running an immediate job. The following example illustrates the immediate execution of the My_PLSQL_Procedure job:

Begin
   CLOUD_SCHEDULER.RUN_JOB( 'My_PLSQL_Procedure;' ); 
End;
/

To learn more, see "DBMS_SCHEDULER" in Oracle Database PL/SQL Packages and Types Reference.

For examples, see "Examples of Using the Scheduler" in Oracle Database Administrator's Guide.

Application Archiving

Modifications to your Oracle Application Express applications can be archived to tables in your database schema. Applications that belong to Database Cloud Services with automatic archiving enabled are archived when they are created and when they are changed. The APEX Application Archive packaged application is used to manually archive applications and to view, manage and restore application archives.

Note:

The archived application content is counted against your tablespace quota. By default, only 5 application versions are maintained. However, you can adjust this value from the APEX Application Archive packaged application. See "Viewing and Managing Application Archives".

Topics:

Scheduling Daily Automatic Application Archiving

You can schedule daily automatic archiving for all applications that belong to your Database Cloud Service. Automatic daily archiving is enabled and disabled from the Database Cloud Service Administration page. Database Cloud Services enabled with application archiving generate an archive for applications when they are created and when they are changed. You can also manually archive from the APEX Application Archive packaged application. To learn more, see "Manually Archiving Applications".

To view and manage archives, use the APEX Application Archive packaged application. To learn more, see "Installing the APEX Application Archive Packaged Application" and "Viewing and Managing Application Archives".

To schedule automatic application archiving:

  1. From the Oracle Cloud home page, go to the My Services page. See "Accessing the My Services Page".

    The My Services home page appears.

  2. Select a Database Cloud Service.

    The Overview page displays.

  3. Click the Administration tab.

    The Administration page displays.

    Description of archive_update.gif follows
    Description of the illustration archive_update.gif

  4. Click Application Archiving Update.

    The Update Application Archiving page appears.

  5. Select Enable Application Archive.

    Description of select_archive.gif follows
    Description of the illustration select_archive.gif

  6. Click Update Application Archiving.

    The Administration page displays with a current archive status of Auto Archive Daily.

Note:

The archived application content is counted against your tablespace quota. By default, only 5 application versions are maintained. However, you can adjust this value from the APEX Application Archive packaged application. See "Viewing and Managing Application Archives".

Managing and Viewing Application Archives

The APEX Application Archive packaged application is used to view and manage archives. Application archives are performed when the Database Cloud Service is enabled for automatic application archiving or when a manual archive is performed. To learn more, see "Scheduling Daily Automatic Application Archiving" and "Manually Archiving Applications".

Topics:

Installing the APEX Application Archive Packaged Application

Before you can use the APEX Application Archive packaged application, it must be installed.

To install the Application Archive packaged application:

  1. From the Oracle Cloud home page, go to the My Services page. See "Accessing the My Services Page".

    The My Services home page appears.

  2. Select a Database Cloud Service.

    The Overview page displays.

  3. Click the Applications tab.

    The Applications page displays.

  4. For Packaged Applications, click Install New.

    The Packaged Applications page displays showing all available packaged applications and sample code.

    Description of archive_app.gif follows
    Description of the illustration archive_app.gif

  5. Locate and click the APEX Application Archive application.

    The application information page displays.

  6. Click Install Application.

    The Install Application dialog appears.

  7. For Authentication, select one of the following:

  8. Click Install Application.

    The Application Installed dialog displays.

  9. If you selected Application Express authentication, you will have the option of creating a first user for the application by entering the following information:

    • Create Application Express User - Select this option to create an application user before installation is complete. Otherwise, the user must be created after installation is complete using the Application Express Administration.

    • Username - Enter the username used to log in to the application.

    • Password -Enter the password used to log in to the application.

    • Confirm Password - Enter the same password again to confirm.

    • Email - Enter user's valid email address.

  10. If you selected Oracle Cloud Identity Management, the users currently authorized by Oracle Cloud Identity Management have access to this application. Use the Oracle Cloud Identity Console to add users. See "Managing Service Users" in Getting Started with Oracle Cloud.

  11. To test the application, click Run Application.

Running the APEX Application Archive Application

The APEX Application Archive packaged application is used to view and manage application archives. Before you can run this application, it must be installed. To learn more, see "Installing the APEX Application Archive Packaged Application".

To launch the APEX Application Archive packaged application:

  1. From the Oracle Cloud home page, go to the My Services page. See "Accessing the My Services Page".

    The My Services home page appears.

  2. Select a Database Cloud Service.

    The Overview page displays.

  3. Click the Applications tab.

    The Applications page displays.

    Description of archive_run.gif follows
    Description of the illustration archive_run.gif

  4. Under Packaged Applications for APEX Application Archive, click Run.

    The APEX Application Archive application home page appears.

Viewing and Managing Application Archives

The APEX Application Archive packaged application is used to view and manage application archives. Before you can run this application, it must be installed. To learn more, see "Installing the APEX Application Archive Packaged Application".

To view and manage application archives:

  1. Run the APEX Application Archive application as described in "Running the APEX Application Archive Application".

  2. Click the Manage Archives button.

    The Archives page displays.

  3. To change the maximum number of archives, click Adjust.

    The Preferences dialog appears.

  4. For Max Versions, enter the maximum number of archive versions to save, then Apply Changes.

  5. To remove archives, click Purge All Archives.

    The Purge dialog appears.

  6. For Purge Action, select the action to perform.

  7. Click Purge Archive.

Manually Archiving Applications

You can manually archive applications from the APEX Application Archive packaged application.

To manually archive applications:

  1. Install the APEX Application Archive packaged application as described in "Installing the APEX Application Archive Packaged Application".

  2. Run the APEX Application Archive application as described in "Running the APEX Application Archive Application".

    The APEX Application Archive home page appears.

  3. Click Archive Applications.

  4. Follow on-screen instructions.

Implementing RESTful Web Services

RESTful Web services enable the declarative specification of RESTful services used to access the database. These services work in conjunction with the Oracle Application Express Listener to enable the consumption of these services.

To create a RESTful Web service:

  1. Launch the Database Cloud Service. See "Launching a Database Cloud Service".

  2. Click SQL Workshop.

  3. Click RESTful Services.

  4. To create a RESTful Web service, click Create.

  5. Follow on-screen instructions.

To learn more about implementing RESTful Web services, see "Using RESTful Services" in the Oracle Application Express SQL Workshop Guide.

Calling SOAP and RESTful Web Services

The APEX_WEB_SERVICE package allows you to integrate other systems with Application Express by allowing you to interact with Web services anywhere you can utilize PL/SQL in your application. The API contains procedures and functions to call both SOAP and RESTful style Web services. It contains functions to parse the responses from Web services and to encode/decode into SOAP friendly base64 encoding.This API also contains package globals for managing cookies and HTTP headers when calling Web services whether from the API or by using standard processes of type Web service. Cookies and HTTP headers can be set prior to invoking a call to a Web service by populating the globals and the cookies and HTTP headers returned from the Web service response can be read from other globals.

Note:

All Web services must be secured. Only HTTPS services are supported. Simple HTTP requests will be rejected. The proxy server that is usually configurable is preset as an Oracle provided HTTP proxy server and not changeable by users.

To learn more, see "APEX_WEB_SERVICE" in Oracle Application Express API Reference.

Relevant Links

For your convenience, the Database Cloud Service includes a Resources tab containing several references to relevant documentation, community bulletin boards, sites where you can learn more and find Oracle SQL Developer and Oracle Application Express downloads.

To access the Resources tab:

  1. From the Oracle Cloud home page, go to the My Services page. See "Accessing the My Services Page".

    The My Services home page appears.

  2. Select a Database Cloud Service.

    The Overview page displays.

  3. Click the Resources tab.

    The Resources page displays.

  4. Click one of the links to navigate to resources and downloads: