#include <QCoreApplication>
#include <QtSql>

int main(int argc, char **argv)
{
    QCoreApplication a(argc, argv);
    QVariant clob = QByteArray("ABCD");

    QSqlDatabase db = QSqlDatabase::addDatabase("QOCI");
    qDebug() << "here";
    db.setHostName("hostname");
    db.setUserName("name");
    db.setPassword("pwd");
    db.setPort(1521);
    if (!db.open()) {
        qDebug() << "Can't' open database" << db.lastError();
        return 1;
    }

    QSqlQuery q;
    //q.exec("CREATE TABLE TEST(id number(10), myText clob)");
    q.exec("DELETE FROM TEST WHERE id='1'");
    q.prepare("INSERT INTO TEST VALUES (1, :txt)");
    q.bindValue(":txt", clob);
    if (!q.exec()) {
        qDebug() << "INSERT error" << q.lastError();
        return 2;
    }

    QSqlQuery selectQ;
    if (!selectQ.exec("SELECT myText from TEST WHERE id='1'")) {
        qDebug() << "SELECT error:" << selectQ.lastError();
        return 3;
    }
    if (selectQ.next()) {
        qDebug() << "should see a QByteArray with ABCD" << selectQ.value(0);
    } else {
        qDebug() << "nothing to read";
    }
    return 0;
}