EXEC SQL INSERT INTO MY_TABLE (COL1, COL2, COL3)
    VALUES(:varOne, :varTwo, EMPTY_BLOB())
    RETURNING COL3 INTO :varThree;