I have an ApEx application that uploads a file, then puts the data in a custom table. We just upgraded from ApEx 3.1 to 3.2, and now I get a wwv_flow.accept error when I try to upload a file. The page has the user save the text, then allows for a file attachment and processes this as an attachement. Here is my code when the user presses the apply changes button.
begin
-- Update updated information
if :P9_ID is not null then
update news_postings
set last_updated = sysdate,
updated_by = :APP_USER
where id = :P9_ID;
end if;
-- Update image file
if (:P9_FILE_NAME is not null and :P9_ID is not null) then
update news_postings
set file_name = :P9_FILE_NAME,
image = (select blob_content from apex_application_files where name = :P9_FILE_NAME),
mime_type = (select mime_type from apex_application_files where name = :P9_FILE_NAME)
where id = :P9_ID;
delete from apex_application_files where name = :P9_FILE_NAME;
end if;
end;
>
I have tried the ALTER SYSTEM FLUSH SHARED POOL fix, but this has no affect. The error happens every time I upload a file. If I press the reload button in the browser, the data will finally go through, but this is not consistent, sometimes working on the first, second or more retries.
Thanks, Ken