APPEND Procedure Signature 6

Appends an array of VARCHAR2 to an array.

Syntax

MEMBER PROCEDURE append (
    p_value          IN   apex_t_varchar2,
    p_spread         IN   BOOLEAN              DEFAULT FALSE,
    p_omit_empty     IN   BOOLEAN              DEFAULT TRUE );

Parameters

Parameter	Description
p_value	The array.
p_spread	Whether to append the values to the currently opened array as opposed to creating a new one.
p_omit_empty	Whether to omit the array if it is empty.

Example

Create an array that appends an array of type VARCHAR2.

declare
    l_obj apex_t_javascript_object  := apex_t_javascript_object();
    l_arr apex_t_varchar2           := apex_t_varchar2( 'foo', 'bar', 'baz' );
begin
    l_obj.open_array;
    l_obj.append( l_arr );
    l_obj.append (
        p_value     => l_arr,
        p_spread    => true );
    l_obj.close_array;

    sys.dbms_output.put_line( l_obj.to_clob );
end;

Output:
    [["foo","bar","baz"],"foo","bar","baz"]