[Home] [Help]
656:
657: l_value:=CCT_COLLECTION_UTIL_PUB.GET(p_param_value,l_param,l_return_status);
658: -- rem dbms_output.put_line('Inserting Server Param='||l_param||' value='||l_value||' for server_id='||to_char(p_server_id));
659:
660: Select ieo_svr_values_s1.nextval
661: into l_value_id
662: from dual;
663:
664: Insert into ieo_svr_values(value_id,server_id,param_id,value,value_index
660: Select ieo_svr_values_s1.nextval
661: into l_value_id
662: from dual;
663:
664: Insert into ieo_svr_values(value_id,server_id,param_id,value,value_index
665: ,creation_date,created_by,last_update_date,last_updated_by)
666: Select l_value_id,p_server_id,l_param_id,l_value,0
667: ,sysdate,1,sysdate,1 from dual
668: where not exists (Select 1 from ieo_svr_values
664: Insert into ieo_svr_values(value_id,server_id,param_id,value,value_index
665: ,creation_date,created_by,last_update_date,last_updated_by)
666: Select l_value_id,p_server_id,l_param_id,l_value,0
667: ,sysdate,1,sysdate,1 from dual
668: where not exists (Select 1 from ieo_svr_values
669: where server_id=p_server_id and param_id=l_param_id);
670: Exception
671: When others then
672: null;
786: If l_server_group_id is not null Then
787: Begin
788: Select m.middleware_id,m.config_name,t.middleware_type
789: into l_mw_id,l_mw,l_mw_type
790: from cct_middlewares m,ieo_svr_servers s,ieo_svr_params p,ieo_svr_values v,cct_middleware_types t
791: where s.type_id=10160
792: and s.member_svr_group_id=l_server_group_id
793: and v.server_id=s.server_id
794: and v.param_id=p.param_id