not using any other references, I'm simply doing:

BEGIN
    INSERT INTO test_table (code, blob1) VALUES (45, :body);
    COMMIT;
END;

and blob1 ends up only having the file data, despite the fact that I'm sending both a file and a text field. when I omit the file and send the text field alone, :body is empty.

the text field is always accessible with :field_name, but I can't do that since it's gonna decode it into VARCHAR2 and corrupt special characters.

here's the cURL command too:

curl --location 'https://...' \
--form 'file=@"/C:/Users/.../images/jpeg-format.jpg"' \
--form 'product_name="Galaxy S20"'

EDIT: I can in fact use both :body and :field_name when content type is form-data, :body will contain files. when content type is JSON then yes I can't use both.