Deutsches Application Express Forum (ApEx) -- Installation , Engine / SQL , Anwendungen
IF (:P7_FILE_NAME is not null) THEN INSERT INTO file_subjects(id, NAME, SUBJECT, BLOB_CONTENT, MIME_TYP) SELECT ID, :P7_FILE_NAME, :P7_SUBJECT, blob_content, mime_type FROM wwv_flow_files WHERE name = :P7_FILE_NAME; DELETE from wwv_flow_files WHERE name = :P7_FILE_NAME; END IF;