APEX

Hi all,

I am using APEX 3.1 with Oracle 10.2.0.3 Standard Edition on a Windows 2003 Server (production).

I have an application that I developed to list some records based on some user defined filters on the same page. (Report list).

I have check boxes next each record (each record holds a customer's info), so I can select them one by one or select them all and send the selection to a third party application to print customer cards.

My problem is, when the number of records listed is too long, the text value (concatenation of IDs separated with semi-colon) I am sending gets too long, therefore causes problems with printing on the other side (URL text length limit, or the other application's internal limits).

Is there a way of entering these select record's IDs into a temporary table (or even a permanent one), so that the other application can just select the records based on the values listed in that table, instead of using INSTR function with a very long text looks like this? (12623;28131;125;3412312...)

Just like the way the "Export to Excel" function exports the records, can I get a unique number each time I refresh my report with different filter values, so I can use that to enter into the temporary table?

Please see the screen shot here:

Image file:

http://www.flickr.com/photos/24993788@N04/2806273409/

Thanks for your time in advance.
Sinan

Edited by: stopuz on Aug 28, 2008 2:25 PM