Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
HFM - USERPARAMS table - BLOBDATA column

Hello,
Does anyone know how to decipher the "BlobData" column in the USERPARAMS table from an HFM database?
It looks like hexadecimal numbers or character codes but I have no idea what they mean. I would think that field carries information such as dates but probably more.
Any help appreciated :-)
Thank you very much in advance.
Alexis
Answers
-
Hi Alexis,
See if this KM helps to understand how "BLOBDATA" appeared in UserParams table:
Regards,
Suresh.
-
You're correct, they're hex character codes.
There are free online tools you can use to convert them easily.
https://www.rapidtables.com/convert/number/hex-to-ascii.html
So:
3C003F0078006D006C002000760065007200730069006F006E003D00220031002E0030002200200065006E0063006F00640069006E0067003D0022005500540046002D00310036004C004500220020007300740061006E00640061006C006F006E0065003D0022006E006F0022003F003E003C004100500050005F00530045005400540049004E00470053003E003C005500490043006F006D0070006F006E0065006E00740020006E0061006D0065003D00220072006F00770046006500740063006800530069007A00650022003E00350030003C002F005500490043006F006D0070006F006E0065006E0074003E003C005500490043006F006D0070006F006E0065006E00740020006E0061006D0065003D002200530069006E0067006C00650043006C00690063006B0054006F00450064006900740022003E0074007200750065003C002F005500490043006F006D0070006F006E0065006E0074003E003C005500490043006F006D0070006F006E0065006E00740020006E0061006D0065003D00220063006F006C0046006500740063006800530069007A00650022003E00350030003C002F005500490043006F006D0070006F006E0065006E0074003E003C002F004100500050005F00530045005400540049004E00470053003E00
Converts down to this:
<?xml version="1.0" encoding="UTF-16LE" standalone="no"?><APP_SETTINGS><UIComponent name="rowFetchSize">50</UIComponent><UIComponent name="SingleClickToEdit">true</UIComponent><UIComponent name="colFetchSize">50</UIComponent></APP_SETTINGS>
-
Jeo123, thank you for your response!
Actually found some built-in function in SQL to convert to ACSII.
Syntax below:
select utl_raw.cast_to_varchar2(dbms_lob.substr(BLOBDATA))
from HYP_HFM.UBRHFM_USERPARAMS
Best,
Alexis