7.4 SDO_NFE.CREATE_MODEL_STRUCTURE

Format

SDO_NFE.CREATE_MODEL_STRUCTURE(
     model_name    IN VARCHAR2,
     edition_mode  IN NUMBER,
     versionable   IN VARCHAR2
) RETURN NUMBER;

Description

Creates the tables and metadata for an NFE model.

Parameters

model_name

Name to be given to the lNFE model.

edition_mode

Edition mode. Must be SDO_NFE.FROM_SCRATCH or SDO_NFE.OVER_EXIST_NETWORK.

versionable

The string value Y if the model will be versionable, otherwise N.

Usage Notes

This function returns the new model's ID value.

Examples

The following example creates a versionable model named MODEL01 with the SDO_NFE.FROM_SCRATCH edition mode.

DECLARE
  model_id      NUMBER;
  model_name    VARCHAR2(50) := 'MODEL01';
  edition_mode  NUMBER       := SDO_NFE.FROM_SCRATCH;
  versionable   VARCHAR2(1)  := 'Y';
BEGIN
  model_id := SDO_NFE.create_model_structure( model_name, edition_mode, versionable );
END;
/