The hack's fine, you just have to be aware that "clob" and "varchar" aren't compatible operand types, though Oracle's perfectly happy letting you store a "varchar" in a "clob".
Besides everytime I wrestle with CLOBs I become even more appreciative of PG's long varchars!