# How does insert a file (blob type) with "loadUpdateData"

**URL:** <https://forum.liquibase.org/t/how-does-insert-a-file-blob-type-with-loadupdatedata/4730>\
**Category:** Liquibase Development\
**Created:** [October 15, 2020, 3:54pm UTC](https://forum.liquibase.org/t/how-does-insert-a-file-blob-type-with-loadupdatedata/4730 "2020-10-15T15:54:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jvalderr](https://avatars.discourse-cdn.com/v4/letter/j/9fc348/32.png) [@jvalderr](https://forum.liquibase.org/u/jvalderr)\
**Post date:** [October 15, 2020, 3:54pm UTC](https://forum.liquibase.org/t/how-does-insert-a-file-blob-type-with-loadupdatedata/4730/1 "2020-10-15T15:54:17Z")

</div>

Hi All!

I’m trying to insert a file (blob type column) into a Oracle database with loadUpdateData (I’ve set a CSV file with the path to the file and the others values of the table) but when I execute Liquibase:update I get this error:

[ERROR] Reason: liquibase.exception.DatabaseException: ORA-01465: invalid hex number  
[ERROR] ORA-06512: en lÝnea 8  
[ERROR] [Failed SQL: DECLARE  
[ERROR] v\_reccount NUMBER := 0;  
[ERROR] BEGIN  
[ERROR] SELECT COUNT(\*) INTO v\_reccount FROM org\_archivo WHERE ID = 717714;  
[ERROR] IF v\_reccount = 0 THEN  
[ERROR] INSERT INTO org\_archivo (ID, VERSION, NOMBRE, CONTENIDO, FECHACREACION, TIPOARCHIVO, USUARIO, SEMANTICA, TAMANO) VALUES (717714, 0, ‘lineasOT.jrxml’, ‘SIGLO\_2663/ARCHIVO/ORG\_ARCHIVO/lineasOT.jrxml’, to\_date(‘2011-04-01 00:00:00’, ‘YYYY-MM-DD HH24:MI:SS’), 21, 100, ‘REPORT’, 21144);  
[ERROR] ELSIF v\_reccount = 1 THEN  
[ERROR] UPDATE org\_archivo SET CONTENIDO = ‘SIGLO\_2663/ARCHIVO/ORG\_ARCHIVO/lineasOT.jrxml’, FECHACREACION = to\_date(‘2011-04-01 00:00:00’, ‘YYYY-MM-DD HH24:MI:SS’), NOMBRE = ‘lineasOT.jrxml’, SEMANTICA = ‘REPORT’, TAMANO = 21144, TIPOARCHIVO = 21, USUARIO = 100, VERSION = 0 WHERE ID = 717714;  
[ERROR] END IF;  
[ERROR] END;]

Thanks ind advance!

Regards!  
Jorge

---

<div class="post-metadata">

**Author:** ![ronak](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/ronak/32/221_2.png) [@ronak](https://forum.liquibase.org/u/ronak)\
**Post date:** [November 16, 2020, 7:50pm UTC](https://forum.liquibase.org/t/how-does-insert-a-file-blob-type-with-loadupdatedata/4730/2 "2020-11-16T19:50:45Z")

</div>

Hello @jvalderr!

The

> [@jvalderr](#):
>
> ORA-06512

Seems to indicate you have an [error](https://www.techonthenet.com/oracle/errors/ora06512.php) in your stored logic, if I read the error right (apologies I am really only proficient in English), it seems line 8 is in issue?

Are you able to run this stored logic directly against your DB?

Thanks,

Ronak