Defines a new external product.
Input
Parameter | Type | Description |
|---|---|---|
v_product_template | VARCHAR2 | The name of the product template for the product |
v_product_group | VARCHAR2 | The name of the product group the product belongs to |
v_name | VARCHAR2 | The name to assign to the product. |
v_geom | SDO_GEOMETRY | The product boundary. |
Output
INTEGER | The ID of the product that was created. |
Example
DECLARE v_product_id external_product.product_id%type; v_product_template constant product_template.name%type := 'My Template'; v_product_group constant productgroup.name%type := 'HPDProducts'; v_product_name constant external_product.name%type := 'Test External Product'; v_product_boundary constant external_product.geom%type := mdsys.sdo_geometry(2003, p_schema_constants.default_source_geom_srid, NULL, MDSYS.sdo_elem_info_array (1, 1003, 3), MDSYS.sdo_ordinate_array (-72.56, 46.32, -72.498, 46.37)); BEGIN v_product_id := p_externalapi.addProduct(v_product_template, v_product_group, v_product_name, v_product_boundary); dbms_output.put_line('Created External Product: '||v_product_id); END; / |