Select BLOB Data

select substr(utl_raw.cast_to_varchar2(at.column_name), 341, 41) as MSISDN from archive_tbl at where utl_raw.cast_to_varchar2(at.column_name) like '%01287392728%';

CURL Response Time

Http post message which store in request.xml. This command support for SOAP action as well.
curl -o /dev/null -w '\nLookup time:\t%{time_namelookup}\nConnect time:\t%{time_connect}\nPreXfer time:\t%{time_pretransfer}\nStartXfer time:\t%{time_starttransfer}\nRedirect time:\t%{time_redirect}\n\nTotal time:\t%{time_total}\n' -H 'SOAPAction: ""' --header "Content-type: application/soap+xml" -i -d @request.xml -X POST http://www.google.com

OracleValidConnectionChecker - Unexpected error in pingDatabase

Error
[org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker] Unexpected error in pingDatabase

Resolution
Remove the Oracle lib (ojdbc14.jar) from your Ear or War and place it at jboss server/lib directory