APEX

Hi All and thanks fro any assistance.

I am trying to Execute the following pl/sql Code in a dynamic action however get the following error - AJAX call returned server error ORA-01403: no data found for Execute PL/SQL code.

I have all page items iin the page items to submit section.

declare
  l_file_comments  IMM_DOCUMENTS.FILE_COMMENTS%type;
  l_file           IMM_DOCUMENTS.FILE_BLOB%type;
  l_filename       IMM_DOCUMENTS.FILENAME%type;
  l_mimetype       IMM_DOCUMENTS.FILE_MIMETYPE%type;
  l_charset        IMM_DOCUMENTS.FILE_CHARSET%type;

begin
    select f.blob_content,
           f.filename,
           f.mime_type,
           nvl(f.file_charset, f.dad_charset)
      into l_file,
           l_filename,
           l_mimetype,
           l_charset
      from wwv_flow_files f
     where f.name = :P80_FILE;

  if l_file is not null then
    insert into IMM_DOCUMENTS
    (
      sub_id,
      document_type_id,
      filename,
      file_blob,
      file_comments,
      file_mimetype,
      file_charset
    )
    values
    (
      :P80_SUB_ID,
      :P80_DOCUMENT_TYPE_ID,
      l_filename,
      l_file,
      :P80_FILE_DESCRIPTION,
      l_mimetype,
      l_charset
    ) ;

    delete from wwv_flow_files where name = :P80_FILE;
  end if;
end;