Hi there,
I have the following values in my variable :P4_Linie
-9:TEST1:TEST2:TEST3
Now I know how to convert the ":" into "," and how to replace the -9. The -9 is the "all selector" of a checkbox pluging meaning if all checkboxes are checked the value -9 is given before the checkboxes data so sometimes it is there and sometimes not.
I know how to do this in a select statement:
SELECT * FROM mv_auswertung WHERE INSTR (
REPLACE (:P4_LINIE, '-9', '')
':'||Linie||':') > 0
Now I get TEST1,TEST2,TEST3 and now I can use this in a select into query.
But I need apex to do this via PL/SQL process or computation so the item is given to the next page in my items to submit.
I need to submit TEST1,TEST2,TEST3 for my IR. Hoping you can help.
Thx in advance
Thorsten