Databases Reference
In-Depth Information
6.
Create a new page PL/SQL process called Convert To Date to Oracle Date,
as shown in Figure 3-35. Click the Next button.
Figure 3-35. Create Page Process region
7.
On the next page, enter the following code in the Enter PL/SQL Page
Process text area. This code is some dummy code that will convert the text
date into an Oracle date. It will fail if the date format is invalid.
DECLARE
v_format_maskapex_application_page_items.format_mask%type;
v_date date;
BEGIN
-- Get format mask
SELECT format_mask
INTO v_format_mask
FROM apex_application_page_items
WHERE application_id= :app_id
AND page_id= :app_page_id
AND item_name = 'P10_TO_DATE';
-- Convert text date to Oracle date
-- This will fail if P10_TO_DATE has an invalid date format
IF :p10_to_date IS NOT NULL THEN
v_date := to_date(:p10_to_date, v_format_mask);
END IF;
END;
8.
Click the Create Process button to complete the wizard.
