APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Direct Image Insert into Table Oracle APEX24.2

Charbel Eid34 hours ago — edited 34 hours ago

Hi,

i am using oracle apex24.2
i have created a blank page and added a form in it based on a table.

select IMG_ID,
IMAGE,
CREATION_DATE,
FILE_MIME,
FILE_NAME
from HR_APX_IMAGES
where img_id =:P8_SRCH_PERSON_ID;

i have created a button that is defined by a dynamic action.

code of the dynamic action :

insert into HR_APX_IMAGES(img_id,image) values (:P8_IMG_ID,:P8_IMAGE);

for now i am just trying to upload the image id and the image only.

when button pressed its giving me this error :

Ajax call returned server error ORA-01403 no data found in ajax_set_session_state.

the page item P8_IMAGE is an image upload item.

any help ?

Added 34 hours ago

#apex-discussions, #apex20-2, #apex24, #oracle-apex, #oracleapex

3 comments

65 views