AnsweredAssumed Answered

Actual Cost Returns A Blob

Question asked by suhail.sayed on Oct 30, 2014
Latest reply on Oct 31, 2014 by suhail.sayed



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.