Forum Stats

  • 3,853,567 Users
  • 2,264,240 Discussions
  • 7,905,393 Comments

Discussions

HFM - USERPARAMS table - BLOBDATA column

3590471
3590471 Member Posts: 10
edited Mar 20, 2018 2:36PM in Financial Consolidation

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

Tagged:

Answers

  • SureshM-Oracle
    SureshM-Oracle Member Posts: 407 Employee
    edited Mar 16, 2018 6:03AM

    Hi Alexis,

    See if this KM helps to understand how "BLOBDATA" appeared in UserParams table:

    Regards,

    Suresh.

  • Jeo123
    Jeo123 Member Posts: 515 Gold Badge
    edited Mar 19, 2018 2:27PM

    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>

  • 3590471
    3590471 Member Posts: 10
    edited Mar 20, 2018 2:36PM

    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

This discussion has been closed.