Deutsches Application Express Forum (ApEx) -- Installation , Engine / SQL , Anwendungen
declare nID Number; begin if :PXXX_DATEI_NAME is not NULL then select www_seq.nextval into nID from dual; insert into tabelle_REK(id, filename, Name der Blobspalte, MIME_TYPE) select nID, :PXXX_DATEI_NAME, blob_content, mime_type from wwv_flow_files where name = :PXXX_DATEI_NAME; :PXXX_ID := nID; delete wwv_flow_files where name = :PXXX_DATEI_NAME; end if; end;