Hi
I’ve plsql block which fires on load page.
That code basically goes and gets geo-coding and finds the person(s) nearby address entered by user
I use sys_refcursor to get the result and then passing it to json_list
Which further is passed clob type variable item declared;
I assign the value gathered by list to a apex hidden item. To further use it javascript to display on map.
Question: What is size limit of apex item ?
Also length of clob return = 27355
I ask this because code works fine outside apex environment but errors out in apex