I am trying to write a series of SQL scripts that I can use to help automate the maintenance for our group memberships in EM Grid Control 10.2.0.5. I want to be able to use a call to SYSMAN.MGMT_GROUP.MODIFY_GROUP() to place a target into a group via a SQL script, but I don't understand the usage of the SMP_EMD_NVPAIR_ARRAY user defined type. I am not able to find much in the way of documentation on this package. Can anyone help with the syntax I would use in an anonymous PL/SQL block?
I understand that I could use EMCLI to accomplish the same thing, but that cannot be done inside of a SQL script and using SQL or PL/SQL to accomplish this is a hard requirement.
Any assistance would be greatly appreciated!