declare
    p_blob blob;
    cursor c is 
    select id||'-'||file_name name, file_name
      from azhs.sv_tree_kd
     where id = 344;--:P2_ID;
         v c%rowtype;
begin
    open c; fetch c into v; close c;
    p_blob := azhs.pac_data.get_blob('PKO_TREE', v.name);--возвращает blob
    insert into APEX_APPLICATION_TEMP_FILES(APPLICATION_ID, name, filename, MIME_TYPE, CREATED_ON,  blob_content)
         values (NV('APP_ID'),file_name,file_name, 'application\pdf', sysdate,   p_blob);
end;