There are times when you need to convert the data being returned in your sql query to match the data type of your variable.
Retrieving a CLOB in iBatis
When I was but a youngling and the Force was yet to fully develop within me, I had issues calling stored procedures which returned a CLOB.
How Smartphone Users See Each Other
Some random Friday fun..