Manage Customer Installed Procedures (CIP) - Intergraph Smart Materials - Version 10.1 - Help - Hexagon

Intergraph Smart Materials Web Help (10.1)

Language
English
Product
Intergraph Smart Materials
Subproduct
Web
Search by Category
Help
Smart Materials/Smart Reference Data Version
10.1

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.

  • It is not allowed to modify packages with prefix w_ and suffix _custom as these are only used as interface from bir_spmat to m_sys schema.

  • You can modify packages with prefix m_pck_ and suffix _custom. Following rules apply for this.

    • You are not allowed to change the signature (everything which is part of the header, like parameters and return variables) for procedures which are delivered by Hexagon.

    • If you want to add your own CIPs, this needs to be done at the end of the specification. Otherwise it will cause issues with Classic.

    • You are allowed to change the code of procedures and functions in the body. For delivered procedures and functions only the code block between BEGIN and END should be touched.

    • These changes are backed up and saved during an upgrade of Smart Materials. You have to bring them back manually after an upgrade.

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.