Hello everyone, I hope you are doing well! I have an error when I want to save two tables in a form, using an onSubmit process with pl/sql code and this error is linked to the SYMBOLEBLOB column that I use to save images here is the error code: 1 error has occurred ORA-01465: invalid hex number and here is the code thank you :
DECLARE
v_organisation_id SGP_ORGANISATION.id%TYPE;
BEGIN
-- Insert into the Organisation table
INSERT INTO SGP_ORGANISATION(
LOCATION_ID,
NOM,
DATE_CREATION,
TELEPHONE,
EMAIL,
SITEWEB,
DESCRIPTION,
NOMBREMEMBRES,
SYMBOLEBLOB
) VALUES (
:P5_LOCATION_ID,
:P5_NOM,
:P5_DATE_CREATION,
:P5_TELEPHONE,
:P5_EMAIL,
:P5_SITEWEB,
:P5_DESCRIPTION,
:P5_NOMBREMEMBRES,
:P5_SYMBOLEBLOB
) RETURNING id INTO v_organisation_id;
-- Insert into the PartiePolitique table using the newly created organisation ID
INSERT INTO SGP_PARTIEPOLITIQUE (
FOUNDEDDATE,
PRESIDENT,
IDEOLOGIE,
PROGRAMMES,
ELUS,
organisation_id
) VALUES (
:P5_FOUNDEDDATE_1,
:P5_PRESIDENT_1,
:P5_IDEOLOGIE_1,
:P5_PROGRAMMES_1,
:P5_ELUS_1,
v_organisation_id -- Use the organisation ID created above
);
-- Commit the transaction
COMMIT;
END;