Idea Summary
- Enable support for pasting images directly into the Rich Text Editor (RTE) in Oracle APEX, with automatic conversion of images into Base64 format or file references, and storage in a CLOB or associated BLOB item. This would allow users to copy and paste images seamlessly along with text content inside applications.
Use Case
- In business applications, users often draft notes, emails, comments, or knowledge base articles where screenshots and inline images are critical for communication.
- Customer service teams can paste images into case descriptions.
- Training or documentation teams can embed screenshots in instructional content.
- Internal collaboration tools (chat, wiki, announcement boards) benefit from rich content with pasted images.
- Without this feature, users must manually upload images as attachments and link them, which breaks the natural workflow.
Preferred Solution (Optional)
- Enhance the APEX Rich Text Editor (RTE) to support image paste events.
- When a user pastes an image, automatically:
- Convert the image into Base64 and store it in the CLOB (inline with text), or
- Save the image in a BLOB column (via automatic upload) and insert a file reference/URL in the CLOB.
- Provide developer options to choose the storage method (Base64 in CLOB or file in BLOB).
- Maintain compatibility with existing RTE features and security filters.
- Previously, CKEditor already had a Clipboard + Upload Image plugin option, which supports copy–paste of images. But Oracle APEX 24.2 CKEditor is not available.