Trying to change the docname to bring back a blank i instead get a resultSet error:
Java Side;
String filepath = foldername.trim() +"templates/" + control.getCoreports() + docname1 + ".docx";
String outpath = foldername.trim() +"merged/"+ docname1 + ".docx";
postgresql part
update test.coltran set docstored = l_uuid_32, docname1 = p_filnam where bilbatchno = l_bilbatchno;
INSERT into test.table
(id, data, name)
VALUES
(l_uuid_32, pg_read_binary_file(p_filnam), p_filnam);
end if;
now if this file is null it gives a result list error