Hi! I want to add images where users can change the color. One color can be used multiple times on single image, in different areas(left, right, up, down, center). Thanks in advance!
Discy Latest Questions
Could you please explian how to deploy app created in oracle apex into oracle saas
I have 2 Oracle database 12.2 Version۔ One database has schema and the other database has Oracle Apex 18.2. I want to show blob column in apex through view because apex uses parsing schema option. An error occurs when I create a view via dblink in the apex database. create or replace view v_temp as select * from table@dblink; ORA-22992: cannot use LOB locators selected from remote tables I found a function that creates a force view via dblink: create or replace function BLOB_DBLINK ( dblnk in varchar2 ,tbl in varchar2 ,col in varchar2 ,rwid in urowid) return blob is retval blob; tmpraw raw(2000); tmplen number; tmpchk number; chksize number; begin --preset vars chksize:=2000; dbms_lob.createtemporary (retval,true); execute immediate 'select dbms_lob.getlength@'||dblnk||' ('||col||') from '||tbl||'@'||dblnk||' where rowid=:rwid' into tmplen using rwid; -- precalc tmpchk:=floor(tmplen/chksize); -- applicate frist chunks for i in 0 .. tmpchk-1 loop execute immediate 'select dbms_lob.substr@'||dblnk||'('||col||','||chksize||','||((i*chksize)+1)||') from '||tbl||'@'||dblnk||' where rowid=:rwid' into tmpraw using rwid; dbms_lob.append(retval,tmpraw); end loop; -- applicate last entry if (tmplen-(tmpchk*chksize)) > 0 then execute immediate 'select dbms_lob.substr@'||dblnk||'('||col||','||(tmplen-(tmpchk*chksize))||','||((tmpchk*chksize)+1)||') from '||tbl||'@'||dblnk||' where rowid=:rwid' into tmpraw using rwid; dbms_lob.append(retval,tmpraw); end if; return retval; end; But this function is very slow. Is there any other way to create view over the dblink?
Hi everyone, I have one case about dynamic action. Now I have two column named A and B. Column, A is display only which I create dynamic action on A (I don't know how to choose action suitable for my action) to change B. My actions is when A is not null then B = 1 else B= 0; Thank you for your time and in advance.
Hello, I am trying to load a PDF into an Apex application, display it, edit it and print it finally. Any help starting with how to load PDF into Apex would be great. Please let me know. Thank you.
Sort option is enabled for CLOB column in interactive report automatically even though option is not enabled in report column attribute. So when tried to sort the clob field below error message is thrown by application Error: Ajax call returned server error ORA-00932: inconsistent datatypes: expected - got CLOB for worksheet.
I created two items which is Display Image type. When add path in source of items, they looks like in image below. I want to minimize space between those items. Thanks in advance!
Any idea how to do scrollable news region like this in oracle apex. Live Preview WordPress Vertical News Scroller
My Json response is like below. I wanto create report for this data. [{"city":"Stockholm","name":"Lennart Johansson"},{"city":"London","name":"Karl Eriksson"},{"city":"Helsinki","name":"Pekka Hartikainen"},{"city":"Berlin","name":"Mia Svensson"}] My query is SELECT city, name FROM JSON_TABLE ( apex_web_service.make_rest_request(p_url => 'https://api.mocki.io/v1/b043df5a', p_http_method => 'GET'), '$' COLUMNS ( city varchar2(500) PATH '$.city', name varchar2(500) PATH '$.name' ) ) but data is not extracting. Please help
Hi, I have created interactive report which is based on parameter, I need a total to be displayed at the bottom of each column. Please suggest. Thanks.