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

Hello,

 

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.

 

Suhail.

 

Outcomes