Hi everybody,
I use Oracle apex 19.1 with oracle 18c express database.
I want to manually insert (by query sql or pl/sql) an image in a table.
Indeed, I have two tables : personne(ID, NOM_COMPLET, DATE_NAISSANCE, LIEU_NAISSANCE, RESIDENCE, PROFESSION) and piece(PIECE_ID, NUM_PIECE, DATE_ETABLISSEMENT, DATE_VALIDITE, PIECE, NOM_PIECE, PIECE_TYPE, UPDATE_DATE, PERSONNE_ID); I created a form on the person table, and this one contains fields from table PIECE as the field Pièce to load an image.
I therefore wish that at the creation of a person, I can at the same time insert in the table PIECE, the image corresponding to the person created
I ask for your help please. I put my workspace online for the demo I made :
Link : https://apex.oracle.com/pls/apex/f?p=4550:1:705090710746002:::::
Workspace : DEVAPP_WORKSPACE
User : demo
Password : demo123
App : Application 41206 - DEMO PROJECT
Menu : People
Thank you in advance