Styjun

Can you pop microwave popcorn on a stove?

Can you mark a new target with the Hunter's Mark spell if the original target shifts to a different plane?

Yet another calculator problem

A PEMDAS issue request for explanation

Complex conjugate and transpose "with respect to a basis"

Features seen on the Space Shuttle's solid booster; what does "LOADED" mean exactly?

Capacitors with same voltage, same capacitance, same temp, different diameter?

More than three domains hosted on the same IP address

Is there a "right" way to interpret a novel, if not, how do we make sure our novel is interpreted correctly?

The meaning of "offing" in "an agreement in the offing"

antimatter annihilation in stars

Supervisor wants me to support a diploma-thesis software tool after I graduated

I multiply the source, you (probably) multiply the output!

Leaving the USA for 10 yrs when you have asylum

Was Robin Hood's point of view ethically sound?

How can I hint that my character isn't real?

Problem with listing a directory to grep

Galilean transformation vs simple translation

What makes things real?

After a few interviews, What should I do after told to wait?

Do you need to burn fuel between gravity assists?

Bit floating sequence

Chemfig upside down -U> arrow not working in TeXLive 2019

UK citizen travelling to France at the end of November

exercising ARP on a page with plenty of items

APEX - Creating a page with multiple forms linked to multiple related tables… that all submit with one button?List of values with multiple return itemsBranch doesn't pass item valuesHow to create update process for single entry form in APEX 4.1Oracle Application Express plugin development using v4.2.2How can I assign a shared foreign key to all records inserted using the Data Load Wizard?Deleting a row in IR in Apex 4.2Oracle Apex - When I submit the data in a page item to a table in the database, why is the data in the page item disappearing?Insert static data along with data loading wizard utility in Oracle APEXDisplay alert message after inserting a row in table using on demand process in oracle apex

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I have an apex form composed of around 50~ text fields and radio buttons.

I tried to create a page process for automated row processing. It works fine but only if my table has a column for each page item.

even though the page items are plenty, actually the question behind them is the same. So what I really want to perform is to collect those data row by row. i.e.

instead of

1 True False True foo

I'd like to store my data like this

1 True foo
2 True goo
3 False hoo
50 False zoo

Since I couldn't find a way to customize ARP, I decided to do it with some manual work.

However I still have this feeling that my efort is futile. I can't help but thinking there must be some other, wiser solutions than being have to create insert/update statements for entire page. I mean I can't be the only one who came up with this need, right?

Thank you very much in advance.

oracle-apex dml oracle-apex-18.2

share|improve this question

edited Mar 28 at 7:57

Ogun

asked Mar 28 at 7:29

OgunOgun

471111 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You can have your own process that handles any data submitted, but have you tried interactive grids?
  
  – Scott
  Mar 28 at 7:32
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi,Yes, I did. But I have to abide a certain page design. 4 different pages, 12 items per page. I used wizard template to line the pages up. at the final page, by clicking finalize button, all the answers given are need to be stored at my table.
  
  – Ogun
  Mar 28 at 7:53
  

  
  
  
  

add a comment | 

0

I have an apex form composed of around 50~ text fields and radio buttons.

I tried to create a page process for automated row processing. It works fine but only if my table has a column for each page item.

even though the page items are plenty, actually the question behind them is the same. So what I really want to perform is to collect those data row by row. i.e.

instead of

1 True False True foo

I'd like to store my data like this

1 True foo
2 True goo
3 False hoo
50 False zoo

Since I couldn't find a way to customize ARP, I decided to do it with some manual work.

However I still have this feeling that my efort is futile. I can't help but thinking there must be some other, wiser solutions than being have to create insert/update statements for entire page. I mean I can't be the only one who came up with this need, right?

Thank you very much in advance.

oracle-apex dml oracle-apex-18.2

share|improve this question

edited Mar 28 at 7:57

Ogun

asked Mar 28 at 7:29

OgunOgun

471111 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You can have your own process that handles any data submitted, but have you tried interactive grids?
  
  – Scott
  Mar 28 at 7:32
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi,Yes, I did. But I have to abide a certain page design. 4 different pages, 12 items per page. I used wizard template to line the pages up. at the final page, by clicking finalize button, all the answers given are need to be stored at my table.
  
  – Ogun
  Mar 28 at 7:53
  

  
  
  
  

add a comment | 

I have an apex form composed of around 50~ text fields and radio buttons.

I tried to create a page process for automated row processing. It works fine but only if my table has a column for each page item.

even though the page items are plenty, actually the question behind them is the same. So what I really want to perform is to collect those data row by row. i.e.

instead of

1 True False True foo

I'd like to store my data like this

1 True foo
2 True goo
3 False hoo
50 False zoo

Since I couldn't find a way to customize ARP, I decided to do it with some manual work.

However I still have this feeling that my efort is futile. I can't help but thinking there must be some other, wiser solutions than being have to create insert/update statements for entire page. I mean I can't be the only one who came up with this need, right?

Thank you very much in advance.

oracle-apex dml oracle-apex-18.2

share|improve this question

edited Mar 28 at 7:57

Ogun

asked Mar 28 at 7:29

OgunOgun

471111 bronze badges

1 True False True foo

1 True foo
2 True goo
3 False hoo
50 False zoo

share|improve this question

edited Mar 28 at 7:57

Ogun

asked Mar 28 at 7:29

OgunOgun

471111 bronze badges

share|improve this question

edited Mar 28 at 7:57

Ogun

asked Mar 28 at 7:29

OgunOgun

471111 bronze badges

asked Mar 28 at 7:29

OgunOgun

471111 bronze badges

asked Mar 28 at 7:29

OgunOgun

471111 bronze badges

1 Answer
1

active

oldest

votes

0

I hope you can achieve your requirement using APEX_COLLECTION. It stores the data temporarily that are associated with the session of the user currently logged into the application. below is the sample code for your reference.

begin
 if not apex_collection.collection_exists('SAMPLE_COLLECTION') then 
 APEX_COLLECTION.CREATE_OR_TRUNCATE_COLLECTION(p_collection_name => 'SAMPLE_COLLECTION');
 apex_collection.add_member(
 p_collection_name => 'SAMPLE_COLLECTION',
 p_c001 => :P1_TEST_ITEM1,
 p_c002 => :P1_TEST_ITEM2,
 p_c003 => :P1_TEST_ITEM3,
 p_c004 => :P1_TEST_ITEM4,
 p_c005 => :P1_TEST_ITEM5,
 );

 end if;
 end;

You can select the data stored using the below SELECT statement.

select c001, c002,c003,c004, c005 
 from apex_collections where collection_name = 'SAMPLE_COLLECTION'

Please refer this link to explore more on APEX_COLLECTION

share|improve this answer

answered Mar 28 at 9:30

AhamedAhamed

27911 silver badge88 bronze badges

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/4.0/"u003ecc by-sa 4.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55392223%2fexercising-arp-on-a-page-with-plenty-of-items%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

I hope you can achieve your requirement using APEX_COLLECTION. It stores the data temporarily that are associated with the session of the user currently logged into the application. below is the sample code for your reference.

begin
 if not apex_collection.collection_exists('SAMPLE_COLLECTION') then 
 APEX_COLLECTION.CREATE_OR_TRUNCATE_COLLECTION(p_collection_name => 'SAMPLE_COLLECTION');
 apex_collection.add_member(
 p_collection_name => 'SAMPLE_COLLECTION',
 p_c001 => :P1_TEST_ITEM1,
 p_c002 => :P1_TEST_ITEM2,
 p_c003 => :P1_TEST_ITEM3,
 p_c004 => :P1_TEST_ITEM4,
 p_c005 => :P1_TEST_ITEM5,
 );

 end if;
 end;

You can select the data stored using the below SELECT statement.

select c001, c002,c003,c004, c005 
 from apex_collections where collection_name = 'SAMPLE_COLLECTION'

Please refer this link to explore more on APEX_COLLECTION

share|improve this answer

answered Mar 28 at 9:30

AhamedAhamed

27911 silver badge88 bronze badges

add a comment | 

0

I hope you can achieve your requirement using APEX_COLLECTION. It stores the data temporarily that are associated with the session of the user currently logged into the application. below is the sample code for your reference.

begin
 if not apex_collection.collection_exists('SAMPLE_COLLECTION') then 
 APEX_COLLECTION.CREATE_OR_TRUNCATE_COLLECTION(p_collection_name => 'SAMPLE_COLLECTION');
 apex_collection.add_member(
 p_collection_name => 'SAMPLE_COLLECTION',
 p_c001 => :P1_TEST_ITEM1,
 p_c002 => :P1_TEST_ITEM2,
 p_c003 => :P1_TEST_ITEM3,
 p_c004 => :P1_TEST_ITEM4,
 p_c005 => :P1_TEST_ITEM5,
 );

 end if;
 end;

You can select the data stored using the below SELECT statement.

select c001, c002,c003,c004, c005 
 from apex_collections where collection_name = 'SAMPLE_COLLECTION'

Please refer this link to explore more on APEX_COLLECTION

share|improve this answer

answered Mar 28 at 9:30

AhamedAhamed

27911 silver badge88 bronze badges

add a comment | 

I hope you can achieve your requirement using APEX_COLLECTION. It stores the data temporarily that are associated with the session of the user currently logged into the application. below is the sample code for your reference.

begin
 if not apex_collection.collection_exists('SAMPLE_COLLECTION') then 
 APEX_COLLECTION.CREATE_OR_TRUNCATE_COLLECTION(p_collection_name => 'SAMPLE_COLLECTION');
 apex_collection.add_member(
 p_collection_name => 'SAMPLE_COLLECTION',
 p_c001 => :P1_TEST_ITEM1,
 p_c002 => :P1_TEST_ITEM2,
 p_c003 => :P1_TEST_ITEM3,
 p_c004 => :P1_TEST_ITEM4,
 p_c005 => :P1_TEST_ITEM5,
 );

 end if;
 end;

You can select the data stored using the below SELECT statement.

select c001, c002,c003,c004, c005 
 from apex_collections where collection_name = 'SAMPLE_COLLECTION'

Please refer this link to explore more on APEX_COLLECTION

share|improve this answer

answered Mar 28 at 9:30

AhamedAhamed

27911 silver badge88 bronze badges

begin
 if not apex_collection.collection_exists('SAMPLE_COLLECTION') then 
 APEX_COLLECTION.CREATE_OR_TRUNCATE_COLLECTION(p_collection_name => 'SAMPLE_COLLECTION');
 apex_collection.add_member(
 p_collection_name => 'SAMPLE_COLLECTION',
 p_c001 => :P1_TEST_ITEM1,
 p_c002 => :P1_TEST_ITEM2,
 p_c003 => :P1_TEST_ITEM3,
 p_c004 => :P1_TEST_ITEM4,
 p_c005 => :P1_TEST_ITEM5,
 );

 end if;
 end;

select c001, c002,c003,c004, c005 
 from apex_collections where collection_name = 'SAMPLE_COLLECTION'

share|improve this answer

answered Mar 28 at 9:30

AhamedAhamed

27911 silver badge88 bronze badges

answered Mar 28 at 9:30

AhamedAhamed

27911 silver badge88 bronze badges

answered Mar 28 at 9:30

AhamedAhamed

27911 silver badge88 bronze badges