apm_parameter_update (public)

 apm_parameter_update [ -callback callback ] parameter_id package_key \
    parameter_name description default_value datatype [ section_name ] \
    [ min_n_values ] [ max_n_values ]

Defined in packages/acs-tcl/tcl/apm-procs.tcl

Switches:

-callback

(defaults to "apm_dummy_callback") (optional)

Parameters:

parameter_id
package_key
parameter_name
description
default_value
datatype
section_name (optional)
min_n_values (defaults to "1")
max_n_values (defaults to "1")

Returns:

The parameter id that has been updated.

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Source code:

    db_dml parameter_update {
        update apm_parameters
        set parameter_name = :parameter_name,
        default_value  = :default_value,
        datatype       = :datatype,
        description       = :description,
        section_name   = :section_name,
        min_n_values   = :min_n_values,
        max_n_values   = :max_n_values
        where parameter_id = :parameter_id
    }

    db_dml object_title_update {
        update acs_objects
        set title = :parameter_name
        where object_id = :parameter_id
    }

    return $parameter_id

Generic XQL file:

<fullquery name="apm_parameter_update.parameter_update">
    <querytext>
      update apm_parameters
      set parameter_name = :parameter_name,
      default_value  = :default_value,
      datatype       = :datatype,
      description	   = :description,
      section_name   = :section_name,
      min_n_values   = :min_n_values,
      max_n_values   = :max_n_values
      where parameter_id = :parameter_id
    </querytext>
</fullquery>

<fullquery name="apm_parameter_update.object_title_update">
    <querytext>
	update acs_objects
	set title = :parameter_name
	where object_id = :parameter_id
    </querytext>
</fullquery>

packages/acs-tcl/tcl/apm-procs.xql

PostgreSQL XQL file:

packages/acs-tcl/tcl/apm-procs-postgresql.xql

Oracle XQL file:

packages/acs-tcl/tcl/apm-procs-oracle.xql