Create PLSQL Extensions

The following object types can be used while developing User-Extensions:

  • Sequence
  • Procedure
  • Function
  • Package
  • Type

Follow the naming convention and usage instruction mentioned in the User Guide while developing the User Extensions.

Generate an Archive of Created User Extensions

Create a par File

The par file list the object that need to be extracted during archival process. The par file is a newline delimited file. The par file path is passed a parameter during archive.

FN_UPD_FSI_D_ASSETS_CUSTOM

FN_UPD_FSI_D_LIABILITY_CUSTOM

CUSTOM_NO_SEQ_CUSTOM

To execute the archive, execute the following command:

cd $STARTER_KIT_HOME/bin
 . ./archive.sh SILENT "par file absolute path" "project_name"
Example:
. ./archive.sh SILENT "/scratch/devextusr/sampleobjects.par" "project_1"

The archived file will be present under path mentioned against the parameter EXTRACTOR_DUMP_HOME and EXP_DUMP in the init.props file.

For Example given the below values in the init.props file

EXTRACTOR_DUMP_HOME=/scratch/iutusrext/objExtDump

EXP_DUMP=expDump

<EXTRACTION_ID>: This generated by the Archive.

The path will be created as follows:

/scratch/iutusrext/objExtDump/expDump/8/OFS_ALMCS_USER_EXT_2000_29.10.01_1.tar.gz