Creating Custom Scripts
The custom scripts can be created in a text editor, such as Notepad, Textpad, or Oracle SQL Developer. The script may be as short as a single SQL statement, but if it is longer, a delimiter is required between statements. The required delimiter is the forward slash character ("/") on a separate line by itself. Note that stored procedures may be executed in these scripts.
The script is pasted or otherwise loaded into the SCRIPT column of the HPM_SQL_SCRIPT table, as shown in HPM_SQL_SCRIPT. Do not type the script directly into the HPM_SQL_SCRIPT table.
Caution:
Only the system administrator who has the password to the HPM Product schema can create pre- and post-scripts.
To create and load a custom script: