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.
Oracle SQL Query where not already exists
Bhavin
Many thanks for your prompt reply but this query won't work...! Any way I found the solution based on the above query: SELECT DISTINCT p.person_id ,c.contact_det_type_id ,c.description FROM per_contact_dets p ,contact_det_types_lk c WHERE p.person_id = :person_id AND c.contact_det_type_id NOT IN (SERead more
Many thanks for your prompt reply but this query won't work...!
Any way I found the solution based on the above query:
SELECT DISTINCT
See lessp.person_id
,c.contact_det_type_id
,c.description
FROM per_contact_dets p
,contact_det_types_lk c
WHERE p.person_id = :person_id
AND c.contact_det_type_id NOT IN (SELECT p1.contact_det_type_id
FROM per_contact_dets p1
WHERE p1.person_id = p.person_id)
;
Wizard Style Form in Apex
Bhavin
Many thanks Farooq, I will have a look.
Many thanks Farooq, I will have a look.
See lessWizard Style Form in Apex
Bhavin
Hi Vinish, Many thanks for your prompt reply and providing the instant solution. I have checked there is no header process in my page. I think (not sure) the issue is setting the Source of the page item. By default Wizard does not set the Source for the page item so in Source attribute, Type is setRead more
Hi Vinish,
Many thanks for your prompt reply and providing the instant solution.
I have checked there is no header process in my page.
I think (not sure) the issue is setting the Source of the page item.
By default Wizard does not set the Source for the page item so in Source attribute, Type is set to NULL and Used is set to Only when current value in session state is Null.
And in my case I have set the Type to Database Column and Used is set to Always, replacing any existing value in session state.

See lessWizard Style Form in Apex
Bhavin
Hi Vinish, Yes, Cache option is blank. I have also checked the Order Processing wizard on Sample Database Application, that one also doing the same behaviour, cleared out the data. Is there any way not to clear out the data? My settings for a branch:
Hi Vinish,
Yes, Cache option is blank. I have also checked the Order Processing wizard on Sample Database Application, that one also doing the same behaviour, cleared out the data. Is there any way not to clear out the data?
My settings for a branch:

See lessWizard Style Form in Apex
Bhavin
Hello Vinish, I have implemented the same method for all the pages but when I click the PREVIOUS button and go to previous page I loose the data. I have also created a branch to go to the previous page.
Hello Vinish,
I have implemented the same method for all the pages but when I click the PREVIOUS button and go to previous page I loose the data. I have also created a branch to go to the previous page.
See lessWizard Style Form in Apex
Bhavin
Hello Vinish, Further to my earlier message everything is working fine except when I click the PREVIOUS button I am losing the Page Item values (especially for FORM page) which I have already entered. How can I keep the page item values even I do back and forth in wizard? Your help would be appreciaRead more
Hello Vinish,
Further to my earlier message everything is working fine except when I click the PREVIOUS button I am losing the Page Item values (especially for FORM page) which I have already entered.
How can I keep the page item values even I do back and forth in wizard?
Your help would be appreciated.
See lessWizard Style Form in Apex
Bhavin
Hello Vinish sir, My apologies for not coming back earlier as I was not well. I have implemented the steps as you have mentioned earlier by creating a normal table...I can confirm that it's all working fine with IG on a normal temp table and then inserting data from temp table to actual table. ManyRead more
Hello Vinish sir,
My apologies for not coming back earlier as I was not well. I have implemented the steps as you have mentioned earlier by creating a normal table...I can confirm that it's all working fine with IG on a normal temp table and then inserting data from temp table to actual table.
Many thanks for your all help and support.
Wizard Style Form in Apex
Bhavin
Hi Vinish, I have tried the solution as you have suggested but I am struggling in IG. I assume Global Temp Table only works for single entry (not sure) but for multi rows we have to use Apex Collection. Would it be possible for you to make a demo on this?
Hi Vinish,
I have tried the solution as you have suggested but I am struggling in IG. I assume Global Temp Table only works for single entry (not sure) but for multi rows we have to use Apex Collection.
Would it be possible for you to make a demo on this?
Wizard Style Form in Apex
Bhavin
Hi Vinish Sir, Many thanks for your prompt reply and providing the guidance to implement wizard steps. I will update you accordingly.
Hi Vinish Sir,
Many thanks for your prompt reply and providing the guidance to implement wizard steps.
I will update you accordingly.
See lessHow to save data from Interactive grid to Database Table in one go Master Detail form?
Bhavin
When I click the SAVE button, I am getting an error - Cannot insert NULL into Master_Id. I have tried default Save process but did not work so then I have tried manual PL/SQL Code process. # Manual PL/SQL Code for Master DECLARE l_master_id master_table.master_id%type; BEGIN INSERT INTO master_tableRead more
When I click the SAVE button, I am getting an error - Cannot insert NULL into Master_Id.
I have tried default Save process but did not work so then I have tried manual PL/SQL Code process.
# Manual PL/SQL Code for Master
DECLARE
l_master_id master_table.master_id%type;
BEGIN
INSERT INTO master_table (col1, col2, col3)
VALUES (:P1_COL1, :P1_COL2, :P3_COL3)
RETURNING master_id INTO l_master_id;
:P1_MASTER_ID := l_master_id;
END;
# Manual PL/SQL Code for Detail
BEGIN
INSERT INTO detail (master_id, col1, col2, col3)
VALUES (:P1_MASTER_ID, :COL1, :COL2, :COL3)
RETURNING rowid into :ROWID;
END;
See less