APEX

I tried hard pasting my response to Jari's forum response at 7955831

But for some mysterious reason, I am not able to paste any response at all.

So, I am opening up a new thread. Hopefully it will connect :(


Thanks Jari, I have followed your work on the forum link you have posted line by line and word by word.

Now, I am at a stage where I did following but still no rows are pulling up from apex_collections view. The apex_collections view has continued to show no rows returned.

All debug messages show up fine, counters show up with shuttle values and everything is looking as expected and I also changed collection name to upper case but still it is not inserting into apex_collections.

And Below is what I have done step by step.

Step1- Application on Demand Process
KEY SETTINGS FOR THE ON DEMAND PROCESS BELOW
On Demand Process Name - APP_PROCESS
Process Point - On Demand Run this application process when requested by page process
Type - PLSQL Anonymous Block
Page Process Subscriptions - testcol on page 1

declare
list_arr1 apex_application_global.vc_arr2;
n NUMBER := 1;
begin
APEX_COLLECTION.CREATE_OR_TRUNCATE_COLLECTION(p_collection_name => 'TESTCOL');
list_arr1 := apex_util.string_to_table(:P1_X);
FOR i in 1..list_arr1.count
LOOP
n := n +1;
APEX_COLLECTION.ADD_MEMBER (
p_collection_name => 'TESTCOL',
p_c001 => list_arr1(i)
);
END LOOP;
htp.prn('Ok: ' || n);
EXCEPTION WHEN OTHERS THEN
htp.prn(sqlerrm);
END;

Step 2 - Page level HTML Header

<script language="JavaScript" type="text/javascript">
</script>
<script language="JavaScript" type="text/javascript">
function setShuttle(){
alert('Call on demand process. Shuttle value:' + $v('P1_X'));
var get = new htmldb_Get(null,$v('pFlowId'),'APPLICATION_PROCESS=APP_PROCESS',0);
get.add('P1_X',$v('P1_X'));
var gReturn = get.get();
alert(gReturn);
get = null;
gReport.search('SEARCH');
}
</script>

Step 3 - Interactive Report Query

select avalue from valuess,apex_collections where collection_name = 'TESTCOL'
and avalue = C001

Step 4 - Post element button text in shuttle item

<div style="">
<input type="button" value="Submit" onclick ="setShuttle();" />
</div>

At tihs point Jari, I am lost. After all this, still the view apex_collections do not show any rows. I am missing something very obvious, or so I guess.

Thanks,
R

Edited by: Rich V on Oct 23, 2010 4:18 PM