APIs Defined in ECX_CONDITIONS
getLengthForString
PL/SQL Syntax
procedure getLengthForString
(i_string in varchar2);
i_length out pls_integer);
Description
Determines the length of the string passed to it. This procedure may be used in conjunction with the getPositionInString procedure or the Perform Substring action.
Arguments (input)
| i_string
| The input string.
|
Arguments (output)
| i_length
| The length of the input string.
|
getPositionInString
PL/SQL Syntax
procedure getPositionInString
(i_string in varchar2,
i_search_string in varchar2,
i_start_position in pls_integer, default null,
i_occurrence in pls_integer, default null,
i_position out pls_integer);
Description
Parses a concatenated string with delimiters into its individual components. The i_search_string parameter identifies the delimiter. The i_occurrence parameter identifies which occurrence of the delimiter to check for. The return value of the procedure is the position of the first character of the portion of the string you are interested in.
This procedure can be used in conjunction with the getLengthForString procedure or the Perform Substring action.
Arguments (input)
| i_string
| The input string.
|
| i_search_string
| The delimiter used in the concatenated string.
|
| i_start_position
| The character position to begin parsing from.
|
| i_occurrence
| The occurrence of the delimiter to search for.
|
Arguments (output)
| i_position
| The character position of the first character of the portion of the input string you are interested in.
|
getSubString
PL/SQL Syntax
procedure getSubString
(i_string in varchar2,
i_start_position in pls_integer, default 0,
i_length in pls_integer, default 0,
i_substr out varchar2);
Description
Parses a string passed to it given the start position and the length of the substring.
This procedure is used when the length of the substring is maintained in a variable whereas the Perform Substring action is used if the length of the string is a literal value.
Arguments (input)
| i_string
| The input string.
|
| i_start_position
| The character position to begin parsing from.
|
| i_length
| Length from start position of input string to include in resulting substring.
|
Arguments (output)