Manage Customer Installed Procedures (CIP) - Intergraph Smart Reference Data - 2020 (10.0) - Help - Hexagon

Intergraph Smart Reference Data Plus Help (2020)

Language
English
Product
Intergraph Smart Reference Data
Search by Category
Help
Smart Materials/Smart Reference Data Version
2020 (10.0)

You can customize the standard Smart Materials functionality as per your organization requirements. The customizations to the functions are done using the customer installed procedures (CIPs).

Customization should only be done by experienced developers or analysts who are familiar with Smart Materials functionality and the underlying database structure.

You can use the following methods to edit and compile the CIP procedures and functions:

  • SQL*Plus (by Oracle) together with a text editor such as Notepad

  • Any database development tool, for example, SQL Navigator (by Quest Software)

  • Customer CIPs/Forms/Reports page in Smart Materials

  • You can edit the package as a text file and compile it using the standard Oracle SQL*Plus tool, it is recommended to use a development tool for ease of debugging.

  • Use a PC with the Oracle client installed and configured with SQLnet access to the Smart Materials database.

For more information about CIPs, see Smart Materials Customer Installed Procedures.

  1. From the Home page, select Administration > Global Setup > Customer Installed Procedures.

  2. In the Customer Installed Procedures grid, click Edit, to edit the description of the package name.

  3. Click Save.

    SHARED Tip To view the list of database tables used by this package, click the Package Name hyperlink.

  4. In the CIP Reference section, click Edit to edit the Object Type and Comment and click Save.

  5. To view/edit a function or procedure, click the Object Name hyperlink.

    Due to technical restrictions, only objects with a maximum size of 32.767 bytes can be displayed and edited.

  6. To compile the CIP procedure, click the Object Name hyperlink and click Compile in the Edit CIPs dialog.

  7. To assign a menu item (page, page) to a function or procedure, do the following:

    • Click View in Used in Page.

    • Click Add Row.

    • Select a Menu Item from the list.

    • Click Save.