Sign Up

Hey, Dev!
Are you looking for a forum full of active developers to help you?
So if you want to:
➡️ Get answers for your development issues
➡️ Help others
➡️ Write an article
➡️ Get rewarded for your active participation
Then this place is just for you and it is 100% FREE.

Have an account? Sign In


Have an account? Sign In Now

Sign In

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

Sorry, you do not have a permission to ask a question, You must login to ask question.

Forgot Password?

Need An Account, Sign Up Here
Sign InSign Up

OrclQA.Com

OrclQA.Com Logo OrclQA.Com Logo
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • About
Home/Questions

Discy Latest Questions

pavlos
pavlos

pavlos

  • 22 Questions
  • 71 Answers
  • 0 Best Answers
  • 211 Points
View Profile
  • 1
pavlosProfessional
Asked: March 6, 2021

How to change color of image in Oracle APEX?

  • 1

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!  

cssoracle apex
  • 0
  • 11
  • 0
Answer
Bheem
Bheem

Bheem

  • 13 Questions
  • 6 Answers
  • 0 Best Answers
  • 92 Points
View Profile
  • 1
BheemProfessional
Asked: March 5, 2021

How to deploy oracle apex app in oracle SaaS

  • 1

Could you please explian how to deploy app created in oracle apex into oracle saas

apex deployment
  • 0
  • 7
  • 0
Answer
Rameez Tariq
Rameez Tariq

Rameez Tariq

  • 1 Question
  • 0 Answers
  • 0 Best Answers
  • 25 Points
View Profile
  • 0
Rameez TariqContributor
Asked: March 5, 2021

How to create View with Blob column through DBLINK

  • 0

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?

apex-18.2oracle12c
  • 0
  • 90
  • 0
Answer
Huy Nguyen
Huy Nguyen

Huy Nguyen

  • 3 Questions
  • 8 Answers
  • 0 Best Answers
  • 45 Points
View Profile
  • 1
Huy NguyenContributor
Asked: March 5, 2021

Dynamic action on column on Interactive Grid

  • 1

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.

question
  • 3
  • 17
  • 0
Answer
GudDud
GudDud

GudDud

  • 1 Question
  • 0 Answers
  • 0 Best Answers
  • 26 Points
View Profile
  • 1
GudDudContributor
Asked: March 4, 2021

Load PDF into APEX, Edit it and Print it.

  • 1

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.

oracleapex.
  • 0
  • 12
  • 0
Answer
AnuK
AnuK

AnuK

  • 1 Question
  • 0 Answers
  • 0 Best Answers
  • 26 Points
View Profile
  • 1
AnuKContributor
Asked: March 4, 2021

Error: Ajax call returned server error ORA-00932: inconsistent datatypes: expected - got CLOB for worksheet.

  • 1

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.  

apex
  • 1
  • 15
  • 0
Answer
pavlos
pavlos

pavlos

  • 22 Questions
  • 71 Answers
  • 0 Best Answers
  • 211 Points
View Profile
  • 0
pavlosProfessional
Asked: March 4, 2021

How to reduce space between two Display Image items?

  • 0

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!

cssoracle apex
  • 1
  • 27
  • 0
Answer
Bheem
Bheem

Bheem

  • 13 Questions
  • 6 Answers
  • 0 Best Answers
  • 92 Points
View Profile
  • 1
BheemProfessional
Asked: March 3, 2021

Scrollable News with thumbnail

  • 1

Any idea how to do scrollable news region like this in oracle apex. Live Preview WordPress Vertical News Scroller

apex
  • 0
  • 52
  • 0
Answer
Bheem
Bheem

Bheem

  • 13 Questions
  • 6 Answers
  • 0 Best Answers
  • 92 Points
View Profile
  • 1
BheemProfessional
Asked: March 3, 2021

Extract data from json using json_table

  • 1

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

apex
  • 3
  • 65
  • 0
Answer
Hussain
Hussain

Hussain

  • 26 Questions
  • 47 Answers
  • 0 Best Answers
  • 194 Points
View Profile
  • 0
HussainProfessional
Asked: February 28, 2021

Need to displayed Total in Interactive Report

  • 0

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.

apex
  • 2
  • 128
  • 0
Answer
1 2 … 32

Sidebar

Ask Question
Write a Post
  • Recent
  • Answers
  • pavlos

    How to change color of image in Oracle APEX?

    • 0 Answers
  • Bheem

    How to deploy oracle apex app in oracle SaaS

    • 0 Answers
  • Rameez Tariq

    How to create View with Blob column through DBLINK

    • 0 Answers
  • Huy Nguyen

    Dynamic action on column on Interactive Grid

    • 3 Answers
  • hamed
    hamed added an answer hi i want to display image in the report as… March 6, 2021 at 8:33 pm
  • Huy Nguyen
    Huy Nguyen added an answer Thank you for your good idea. March 5, 2021 at 12:09 pm
  • Vinish
    Vinish added an answer Oh, this will work for only new rows. For existing… March 5, 2021 at 11:22 am
  • Vinish
    Vinish added an answer I think you do not need to create the dynamic… March 5, 2021 at 11:14 am
  • Vinish
    Vinish added an answer Are you converting your CLOB to varchar2 in the report?… March 5, 2021 at 6:56 am

Recent Blog Posts

  • Vinish

    Oracle Apex - Display External File in Region

  • Vinish

    Oracle PL/SQL Download BLOB File to Disk

  • Vinish

    Oracle Convert External File to BLOB

  • Vinish

    Oracle Apex Calendar Example

  • Vinish

    Oracle Apex - Open Modal Dialog Page Using JavaScript

Explore

  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • About

© 2021 OrclQA.Com. All Rights Reserved. Privacy Policy