Store procedure or queries to parse KV Pairs list in key1:Value1|... format

[edobellamy]

Hi Has any body done PLSQL to parse UData info?
I know I have in the past but I cannot find them,

If you have some it would be greatly apraciated...

regard,

E

[Kubig]

It depends on UData format,but I do not think that anybody from this forum want write SQL code for your proposal and for you. So,try to put a little bit effort

[edobellamy]

Kubig, the posting asked if somebody has code, not if somebody could write, so put a little effort to read the question before posting.

[Kubig]

Ok,in this way I would say "yes"

[cavagnaro]

hahahaha, yes, me too.
Now edobellamy put an little effort on your side and do it too

[edobellamy]

Why reinvent the wheel

[Kubig]

Reinvent wheel?! The SQL script which is formating the User datas it's not possible to write in general form,because each environment and related UserData is in different format. Such a script would be so unreasonably robust and in most cases completely useless - logical.

[edobellamy]

The code only needs to to extract the keys and the values from a string, or the value for a key, or return nothing if nothing.
very simple, and I done it before many times. Even from blobs and clobs,  No biggie. Only I don't know what I did with my kv sps.
Thanks anyway.   

[Kubig]

You are not right. How would you write general SQL script for KVP pairing,if you did not write from which source/database? KVPs can be stored in a lot of format type and in lot of source (database,WS,file,etc.) . Each point can change dependencies and format of final SQL script.

[edobellamy]

You can get inspired in EVDATA from Call Concentrator, check the BLOB form UCS, cheers

[Kubig]

I do not want inspiration,I do not need anything,you need it :-) I know,how to format KVP for my customers and needs. I'm done with this pointless debate that leads nowhere.