The interface

The dynamic URL example provides access to stored procedures in the database.

An Oracle Web Server is configured to provide access to the following stored procedures in the database:
Table 1. Stored procedures in the database
Stored procedure Description
/db-apps/owa/tr.browse

Gives all users the ability to inquire about travel destinations, prices, and so on.

/db-apps/owa/tr.book

Used to place a booking (travel agent staff or authenticated customers).

/db-apps/owa/tr.change

Used to review or change current bookings.

/db-apps/owa/admin.browse

Used by any staff member to view unrestricted staff information, such as extension number, email address, and photograph.

/db-apps/owa/admin.resume

Gives staff members the ability to view or change their own resume information in the Administration database.

/db-apps/owa/admin.update

Used by Administration staff to update information on staff.