Solved

How to set values in REF_KEY

  • 22 April 2020
  • 1 reply
  • 298 views
H
Rank
Userlevel 6
Badge +14

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?

 

 

icon

Best answer by Hans Andersen 22 April 2020, 14:37

View original

1 reply

H
Rank
Userlevel 6
Badge +14

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;

 

Reply


Terms & ConditionsCookie settings