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

Liquibase Development
1

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

2

Hello @jvalderr!

The

Seems to indicate you have an error 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