Passing values from Array to Text Fields on Apex Form

Question

I am using the following pl/sql in a process to separate some text, which is then displayed and put into two text fields for saving the record. I cannot see anything wrong with the following however when i run the process on my APEX it says 'ORA-01403: no data found'. Is this the correct method of passing the values held in an array to the text fields on my APEX Form?

declare

v_array apex_application_global.vc_arr2;

begin

-- Convert delimited string to array
v_array := apex_util.string_to_table(:P1_OPERATION_JOB,'^');

:P1_ORDER := v_array(1);
:P1_LOCATION := v_array(2);

end;

Tom · Accepted Answer · 2012-11-28 16:19:52Z

You can indeed retrieve values from the array like that. However, getting the ORA-01403 error would indicate that there is no data at either of the positions. (Oracle throws this error when trying to access data at a position with no data in a plsql array, and the same error when a select into retrieves no data)

I'd run this code just to make sure of the output of your split:

DECLARE
    l_vc_arr2    APEX_APPLICATION_GLOBAL.VC_ARR2;
BEGIN
    apex_debug_message.log_message('Debugging string to table output:');
    l_vc_arr2 := APEX_UTIL.STRING_TO_TABLE(:P1_OPERATION_JOB, '^');
    FOR z IN 1..l_vc_arr2.count LOOP
        apex_debug_message.log_message('Item at position '||z||': '||l_vc_arr2(z));
    END LOOP;
END;

Run the page with debug enabled and check the debug messages for the output of the loop. There most likely is no value at one of the positions you're trying to access.

Collectives™ on Stack Overflow

Passing values from Array to Text Fields on Apex Form

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related