4.1.3 Setup Parameters

The Custom PLSQL Properties (Setup Parameters) user interface is used to capture placeholder configuration which might be required during the development of custom PLSQL extensions.

1. To access Custom PLSQL Properties user interface, select Admin Tools, and then select Setup Parameters.

   The Custom PLSQL Properties – Setup Parameters window is displayed.

   Figure 4-1 Setup Parameter

   
   

   

   
   
2. Click Add to define a new custom parameter and enter the following details:
   • Name: Configuration parameter key or name. Name can accept up to 200 characters.
   • Value: Configuration parameter value. Value can accept up to 1000 characters.
   • Description (not mandatory): Provide a description for the parameter and value added. Description can accept up to 1000 characters.
3. Click Save.
4. If you want to edit an already defined parameter, select the checkbox against the Name and change the Name or Value.

   If the Name is already defined, then the system displays a message Parameter name already exists.

Example

The following is an example of how to consume the Custom PLSQL Properties parameter and its value:

• Declare a local variable (lv) in the Custom PLSQL extension definition for parameter SQL_PARALLEL_16_HINT for eg: lv_sql_parallel_16_hint
• Using a SELECT statement fetch the value of the SQL_PARALLEL_16_HINT parameter and assign it to the local variable defined.

  Example:

  lv_sql_parallel_16_hint setup_master.parameter_value%TYPE;
  select parameter_value into lv_sql_parallel_16_hint from setup_master where parameter_name=” SQL_PARALLEL_16_HINT”;