---
title: "Yuji Nakakoshi (@ynakakoshi) | Hashnode"
description: "Oracle APEX enthusiast. Read the latest articles by Yuji Nakakoshi on Hashnode."
url: "https://hashnode.com/@ynakakoshi"
---

@ynakakoshi

# Yuji Nakakoshi

@ynakakoshi · Japan · Joined August 2022

Oracle APEX enthusiast

## Comments

[Started from APEX 23.1, we can use APEX\_APPLICATION\_ADMIN.SET\_AUTHENTICATION\_SCHEME. So the second code could be simpler.](https://hashnode.com/posts/change-your-oracle-apex-authentication-scheme-dynamically/63984dfd70d818b7aaba3c2d/comment/64d181b197ca470130be8aba)

Comment · Article · Aug 7, 2023 · [Change your Oracle APEX authentication scheme dynamically](https://hashnode.com/posts/change-your-oracle-apex-authentication-scheme-dynamically/63984dfd70d818b7aaba3c2d)

[I did research too but the only way I could find was to create a process and remove \_apex\_session before saving it to the database. declare l\_apex\_session varchar2(80); begin l\_apex\_session := '?\_apex\_session=' || :APP\_ID || ',' || :APP\_SESSION; :P2\_CONTENT := replace(:P2\_CONTENT, l\_apex\_session, ''); end;](https://hashnode.com/posts/oracle-apex-231-tinymce-image-upload/649d6fc4d3890995f9381324/comment/64a4cb40411709f0c236f45e)

Comment · Article · Jul 5, 2023 · [Oracle APEX 23.1 - TinyMCE and image upload](https://hashnode.com/posts/oracle-apex-231-tinymce-image-upload/649d6fc4d3890995f9381324)

[Thank you very much, Louis. I followed your instruction and add some changes. In ORDS POST hander, return Object Storage URL instead of ORDS GET URL. Get pre authenticated request URL just after APEX session is authenticated and store it in Application Item. (by Application Computation) declare l\_response dbms\_cloud\_oci\_obs\_object\_storage\_create\_preauthenticated\_request\_response\_t; l\_result dbms\_cloud\_oci\_object\_storage\_preauthenticated\_request\_t; l\_details dbms\_cloud\_oci\_object\_storage\_create\_preauthenticated\_request\_details\_t; l\_url varchar2(4000); preauth\_request\_error exception; begin l\_details := dbms\_cloud\_oci\_object\_storage\_create\_preauthenticated\_request\_details\_t; l\_details.name := 'standard-' || sys\_guid(); l\_details.bucket\_listing\_action := 'Deny'; l\_details.object\_name := null; l\_details.access\_type := 'AnyObjectRead'; l\_details.time\_expires := systimestamp + interval '1' day; l\_response := dbms\_cloud\_oci\_obs\_object\_storage.create\_preauthenticated\_request ( namespace\_name => :G\_NAMESPACE , bucket\_name => :G\_BUCKET , create\_preauthenticated\_request\_details => l\_details , region => :G\_REGION , credential\_name => :G\_CREDENTIAL ); if l\_response.status\_code != 200 then raise preauth\_request\_error; end if; l\_result := l\_response.response\_body; l\_url := 'https://objectstorage.' || :G\_REGION || '.oraclecloud.com' || l\_result.access\_uri; return l\_url; end; Replace the image URL to Pre authenticated URL within editingDowncat. if ( data.attributeNewValue ) { if ( data.attributeNewValue.startsWith("&G\_OBJECT\_STORAGE\_URL.")) { data.attributeNewValue = data.attributeNewValue.replace("&G\_OBJECT\_STORAGE\_URL.","&G\_PREAUTH\_URL."); } } I hope you find it interesting.](https://hashnode.com/posts/ckeditor5-image-upload-part-3/630616cf79f56556d0cb744e/comment/630956c538843b7139783ea5)

Comment · Article · Aug 26, 2022 · [CKEditor5 Image Upload - Part 3](https://hashnode.com/posts/ckeditor5-image-upload-part-3/630616cf79f56556d0cb744e)

[Thank you Louis, your article inspires me a lot. Because I tried to implement the image upload before this wrap-up, I took some different implementation. Let me share. Firstly the content of CKEditor stores in APEX Collection then copied to the table after Automatic-DML process by the code below. Text is stored in CKE\_DOCUMENTS.CONTENT and CKE\_IMAGES.DOCUMENT\_ID is referring CKE\_DOCUMENTS.ID. declare l\_clob clob; l\_link varchar2(32767); l\_id varchar2(80); i pls\_integer; l\_images apex\_t\_varchar2; begin select clob001 into l\_clob from apex\_collections where collection\_name = :P2\_COLLECTION and seq\_id = 1; update cke\_documents set content = l\_clob where id = :P2\_ID; -- find all image url from the content. i := 1; while true loop -- retrieve the image url with the id l\_link := regexp\_substr(l\_clob, :G\_IMAGE\_URL || '/(\[0-9\]+)',1,i); if l\_link is null then exit; else i := i + 1; -- get image id from the url and remember it. l\_id := regexp\_replace(l\_link, :G\_IMAGE\_URL || '/(\[0-9\]+)', '\\1'); apex\_string.push(l\_images,l\_id); end if; end loop; -- initialize the images linked to the document, no effect on new doc. update cke\_images set document\_id = null where document\_id = :P2\_ID; -- link image to the document. update cke\_images set document\_id = :P2\_ID where id in (select column\_value from table(l\_images)); end; Since cascade delete is enabled, any images linked to the document will be deleted along with the document. Images may remain, but housekeeping is simple (just delete the image without document\_id).](https://hashnode.com/posts/ckeditor5-image-upload-additional-thoughts/62dfdeb58730728f62e8e4bf/comment/62eb2fce16f9480a9dac7300)

Comment · Article · Aug 4, 2022 · [CKEditor5 Image Upload - Additional thoughts](https://hashnode.com/posts/ckeditor5-image-upload-additional-thoughts/62dfdeb58730728f62e8e4bf)
