This document is a reference of API calls and related views designed to assist HPD users to integrate source and product data with external applications. It also adds information to the HPD Server in a way that complies with its designed implementation.
The PL/SQL functions, procedures and views presented, can be accessed via Oracle tools such as SQL*Plus as well as through other programming tools supported by Oracle.
The use of these calls assumes that they are done using the authentication defined by the HPD Server utilities, which in turn implements Oracle rules and privileges regarding access to data, such, insert, update, delete and select privileges on tables. In the case where it is not the HPD schema owner using the API methods, the user will have to explicitly indicate who the owner of the object is, for example:
execute hpd_schema_owner.package.procedure; |
or
select * from hpd_schema_owner.view_name; |
Alternatively, the current session parameter can be set at the beginning of the session to point to the appropriate schema owner:
alter session set current_schema = hpd_schema_owner; |
It is also important to note that HPD schemas are created with the default coordinate system set to latitude longitude in decimal degrees, defined by World Geodetic System 1984 (WGS 1984). HPD API will assume coordinates are valid against the default coordinate system except for API calls returning panel feature geometries and panel marker geometries. In this case the coordinates are assumed to be valid against the coordinate system of the panel. For example, the P_PPRAPI.GETGEOMETRY() function.