Oracle Workflow API Reference Release 2.6.3.5 Part Number B12163-02 |
Previous | Next | Contents | Index | Glossary |
function Parameters
(p_string in varchar2,
p_numvalues in number,
p_separator in varchar2) return t_parameters;
Description
Parses a string of text that contains the specified number of parameters delimited by the specified separator. Parameters() returns the parsed parameters in a varray using the T_PARAMETERS composite datatype, which is defined in the WF_EVENT_FUNCTIONS_PKG package. The following table describes the T_PARAMETERS datatype:
Datatype Name | Element Datatype Definition |
---|---|
T_PARAMETERS | VARCHAR2(240) |
Arguments (input)
p_string | A text string containing concatenated parameters. |
p_numvalues | The number of parameters contained in the string. |
p_separator | The separator used to delimit the parameters in the string. |
set serveroutput on
declare
l_parameters wf_event_functions_pkg.t_parameters;
begin
-- Initialize the datatype
l_parameters := wf_event_functions_pkg.t_parameters(1,2);
l_parameters := wf_event_functions_pkg.parameters('1111/2222',2,'/');
dbms_output.put_line('Value 1:'||l_parameters(1));
dbms_output.put_line('Value 2:'||l_parameters(2));
end;
/
Previous | Next | Contents | Index | Glossary |