I am trying to get Actual Cost (cost_actual) value from the fin_cost_plan_details CA Clarity Database Table. But, the result of this value is a blob.
I would like to know if this value of Actual Cost is being stored in any other CA Clarity Database Table? If not, I am trying to crack this blob in the following way:
utl_raw.cast_to_raw(dbms_lob.substr (cost_actual, dbms_lob.getlength (cost_actual), 1)) Actual_Cost from fin_cost_plan_details;
However, I am getting a very long number returned back, which is not what I am looking for.
Any help with this would be very much appreciated. Thank you.