You can also make modifications to the Plan using the UPDATE procedure available in the DBMS_RESOURCE_MANAGER package.

DECLARE

PLAN VARCHAR٢(200);

NEW_COMMENT VARCHAR2(200);

 

BEGIN

PLAN := 'NEW_PLAN'; NEW_COMMENT := 'NEW COMMENT';

SYS.DBMS_RESOURCE_MANAGER.CLEAR_PENDING_AREA; SYS.DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA;

SYS.DBMS_RESOURCE_MANAGER.UPDATE_PLAN ( PLAN,NEW_COMMENT );

SYS.DBMS_RESOURCE_MANAGER.SUBMIT_PENDING_AREA;

COMMIT;

END;

I modified the comment associated with the Plan named NEW_PLAN.