One way to send multiple comma-separated names as parameters in Oracle concurrent program is by using a delimited string value.
For example, in the program parameter definition, set the parameter type as Character and specify the Delimited type as Comma-separated. Then, in the value field, enter the comma-separated list of names with the format of first name and last name separated by a comma.
When the concurrent program is run, the program code can retrieve the parameter value as a string and parse it using the comma as a delimiter to get individual names. The following is an example code snippet to extract names from the delimited string:
DECLARE vnames VARCHAR2(4000) := :PNAMES; vnamearray apexapplicationglobal.vcarr2; BEGIN -- convert delimited string to array vnamearray := apexutil.stringtotable(v_names, ',');
-- loop through each name and extract first and last names FOR i IN 1..vnamearray.count LOOP vfirstname := substr(vnamearray(i), 1, instr(vnamearray(i), ',')-1); vlastname := substr(vnamearray(i), instr(vnamearray(i), ',')+1);
-- do further processing with the extracted names
...
END LOOP; END;
Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss
Asked: 2022-04-18 11:00:00 +0000
Seen: 7 times
Last updated: Nov 04 '22
Can the names of rows be modified in MUI DataGrid?
How to modify the name of existing captions in MS Word?
How can you use linq to choose a specific column from a datatable?
What is the meaning of the role being returned as 'undefined' in DiscordJS?
What is the process of obtaining a column name by using a given row and its corresponding value?
What is the process for changing the name of a dropdown in a Grafana table query?