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.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
How can values be passed in the URL
Vinish
If you are getting no data found error then it means P8_ID is not having the value. You need to double-check on this.
If you are getting no data found error then it means P8_ID is not having the value. You need to double-check on this.
See lessCreate column in interactive report to redirect to corresponding page
Vinish
You are right....
You are right....
See lessCreate column in interactive report to redirect to corresponding page
Vinish
Usage of elsif with the case is wrong. Below is the right syntax: case when nvl(STATUS,'APPROVED')='APPROVED' then 'f?p=&APP_ID.:100:8:&APP_SESSION.:::8:P8_ID:'||ID when nvl(STATUS,'REQUESTED')='REQUESTED' then 'f?p=&APP_ID.:100:9:&APP_SESSION.:::9:P9_ID:'||ID else '#' end LINKRead more
Usage of elsif with the case is wrong. Below is the right syntax:
See lessMy workspace in apex.oracle.com was locked and my admin password don’t work
Vinish
On the apex.oracle.com login page, scroll below, and there you will see some useful links. Try them to resolve your issue.
On the apex.oracle.com login page, scroll below, and there you will see some useful links. Try them to resolve your issue.
See lessPre-Rendering Process Insert Data in Form
Vinish
If you are using a DA to execute the above query, then you must add P9_TBL2_ID in the items to submit field.
If you are using a DA to execute the above query, then you must add P9_TBL2_ID in the items to submit field.
See lessTwo ajax callback process with single button problem
Vinish
Welcome back Afzal. Thank you.
Welcome back Afzal. Thank you.
See lessTwo ajax callback process with single button problem
Vinish
Instead of two dynamic actions to execute JS code, write both codes into one JS code. First for insert_master and then below for insert_detail. Try it.
Instead of two dynamic actions to execute JS code, write both codes into one JS code.
First for insert_master and then below for insert_detail.
Try it.
See lessORA-06502: PL/SQL: numeric or value error- oracle
Vinish
Also, check for TBL1ID in the table and Apex. Because this error occurs only when we try to insert varchar2 in numeric or comparing numeric with varchar2.
Also, check for TBL1ID in the table and Apex.
Because this error occurs only when we try to insert varchar2 in numeric or comparing numeric with varchar2.
See lessORA-06502: PL/SQL: numeric or value error- oracle
Vinish
What data type is for column1 and column2? And what is the type you defined in the Apex?
What data type is for column1 and column2? And what is the type you defined in the Apex?
See lessConcate Single field in oracle plsql having different data
Vinish
Try the below query: select listagg(div, '/') within group (order by ac_cd) divs, ac_cd from yourtable group by ac_cd
Try the below query:
See less