apex upload store as clob

i'll provide a function which i have used in my latest project.This function getting uploaded blob content and converting this to clob.

you know apex file browse item storing uploded content into wwv_flow_files as blob after that developer responsible for storing this content in application spesific tables via fetching from wwv_flow_files

if you need to store your uploded content from apex as clob
you can use this function



FUNCTION uploaded_clob(p_name IN VARCHAR2) RETURN CLOB IS

l_clob_content CLOB;
l_blob_content BLOB;
l_w PLS_INTEGER;
l_d_offset PLS_INTEGER := 1;
l_s_offset PLS_INTEGER := 1;
l_lc PLS_INTEGER := dbms_lob.default_lang_ctx;

BEGIN

dbms_lob.createtemporary(lob_loc => l_clob_content, cache => TRUE);

SELECT *
INTO l_blob_content
FROM (SELECT t.blob_content
FROM wwv_flow_files t
WHERE t.NAME = p_name
ORDER BY created_by DESC)
WHERE rownum < 2;

dbms_lob.converttoclob(dest_lob => l_clob_content,
src_blob => l_blob_content,
amount => dbms_lob.lobmaxsize,
dest_offset => l_d_offset,
src_offset => l_s_offset,
blob_csid => dbms_lob.default_csid,
lang_context => l_lc,
warning => l_w);

RETURN l_clob_content;

END uploaded_clob;

Comments

Post a Comment

Popular posts from this blog

How to add pagination to django comments for your model

First step is import Comment and ContentType to your view like below from django.contrib.comments.models import Comment from django.contrib.contenttypes.models import ContentType Second step is defining your model which you want to paginate its comments content_type_id= ContentType.objects.get_for_model( YOUR_MODEL_NAME ) Last get comments of specific instance of your model class with defining object_pk as filter parameter comments = Comment.objects.filter(content_type=content_type_id,object_pk=quote_id) here is complete view code from django.core.paginator import Paginator, InvalidPage, EmptyPage from django.contrib.comments.models import Comment from django.contrib.contenttypes.models import ContentType def quote_show_page(request,quote_id): quote = get_object_or_404(Quote, id=quote_id) content_type_id=ContentType.objects.get_for_model(Quote) comments = Comment.objects.filter(content_type=content_type_id,object_pk=quote_id) paginator = Paginator(comments, 5) # Show 5 comments pe...
Read more

Raspberry pi zeroyu komut satırı modda otomatik wifi ye bağlama gizli ssid

http://zierfischkaefig.de/merkblaetter/raspberry-pi-edimax-ew-7811un-und-ein-verstecktes-wlan/ Bugün sipariş ettiğim raspberry pi zero elime geçti. İnanılmaz küçük bir bilgisayar ilk gördüğümdeki heyecanı şaşkınlığı herhalde hiç unutmayacağım.  Yukardaki makaledeki ayarlar ile raspberry pi zero yu cli modda internete wifi adaptör(edimax kolay ve hızlıca tanınıyor) otomatik internete bağlayabilirsiniz
Read more

Pyppeteer fix for BrowserError: Browser closed unexpectedly

if you are having an error related with Pyppeteer   BrowserError: Browser closed unexpectedly   is just the error you get when Chrome crashes for whatever reason. It would be nice if pyppeteer printed out the error, but it doesn't. To track things down, it's helpful to pull up the exact command that pyppeteer runs. You can do that this way: from pyppeteer.launcher import Launcher ' '.join(Launcher().cmd) run output from command line and find missing libraries and install it.
Read more