Hi all,
I have a key_ref:
KEY_REF:= ‘BOM_TYPE_DB=M^CONTRACT=1^PART_NO=15000^ROUTING_REVISION=2^’
I would like to replace some of the values. E.g. ROUTING_REVISION=3
I was expecting to be able to do this:
client_sys.Set_Key_Reference(KEY_REF, 'ROUTING_REVISION','3');
but the function does not exists.
What is the easiest way doing this?
Best answer by Hans Andersen
Made the missing function
function Set_Key_Reference(key_ref_ varchar2, key_name_ varchar2, key_value_ varchar2)
return varchar2
is
key_ref_item_ varchar2(1000);
begin
key_ref_item_:= key_name_ || '=' || Client_sys.Get_Key_Reference_Value(key_ref_, key_name_);
return replace(key_ref_, key_ref_item_, key_name_ || '=' || key_value_);
end Set_Key_Reference;
Made the missing function
function Set_Key_Reference(key_ref_ varchar2, key_name_ varchar2, key_value_ varchar2)
return varchar2
is
key_ref_item_ varchar2(1000);
begin
key_ref_item_:= key_name_ || '=' || Client_sys.Get_Key_Reference_Value(key_ref_, key_name_);
return replace(key_ref_, key_ref_item_, key_name_ || '=' || key_value_);
end Set_Key_Reference;
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.