Databases Reference
In-Depth Information
);
IF l rest result.extract('//Error/text()').getnumberval() = 0
THEN
l found count := l rest result.extract('//Found/text()').getnumberval();
IF l found count = 1
THEN
IF l rest result.extract('//Result/quality/text()').getstringval() >= 87
--Address match with street match (or better)
THEN
apex util.set session state(l lat item,
l rest result.extract('//Result/latitude/text()').getstringval());
apex util.set session state(l long item,
l rest result.extract('//Result/longitude/text()').getstringval());
ELSE
clear lat long;
END IF;
ELSE
clear lat long;
END IF;
ELSE
l error := l rest result.extract('//ErrorMessage/text()').getstringval();
RAISE APPLICATION ERROR(-20001, 'Yahoo error: ' || l error);
END IF;
END IF;
RETURN l retval;
END geocode execution;
Developing a Dynamic Action Plug-in
In this tutorial you will create a Dynamic Action plug-in that enhances the end-user experience while
working with cascading select lists. APEX 4.0 introduced declarative support for cascading lists of values
which greatly increased the likelihood they would be used when working with hierarchical data. Most of
the time, hierarchical data will have a one-to-many relationship between parents and children, such as
departments to employees (see Figure 11-23).
Figure 11-23.
Standard one-to-many relationship
