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.
-
From the Home page, select Administration > Global Setup > Customer Installed Procedures.
-
In the Customer Installed Procedures grid, click Edit, to edit the description of the package name.
-
Click Save.
To view the list of database tables used by this package, click the Package Name hyperlink.
-
In the CIP Reference section, click Edit to edit the Object Type and Comment and click Save.
-
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.
-
To compile the CIP procedure, click the Object Name hyperlink and click Compile in the Edit CIPs dialog.
-
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.
-