To edit and compile the CIP procedures and functions, you can use:
-
SQL*Plus (by Oracle) together with a text editor such as Notepad
-
Any database development tool, for example, SQL Navigator (by Quest Software)
-
A.60.37 Customer CIPs/Forms/Reports screen in Smart Materials
The methods are described in the following chapters.
Although you can edit the package as a text file and compile it using the standard Oracle SQL*Plus tool, it is recommended that a development tool be used for ease of debugging.
For all three methods, the work must be done on a workstation with the Oracle client installed with configured SQLnet access to the Smart Materials database.