Hi,
Running APEX 19.1. I have a Process type PL/SQL code with a cursor. When I run the page, the spinner is rotating indefinetely and the page is not displayed. Is it because the loop is running indefinetely ?
Here is the code :
DECLARE
v_TAG_NUMBER varchar2(256) ;
v_RECV_QTY varchar2(256) ;
dummy_ident_pk NUMBER;
dummy_unit_pk NUMBER;
CURSOR c IS
select col001, col002
from apex_application_temp_files f,
table( apex_data_parser.parse(
p_content => f.blob_content,
p_add_headers_row => 'Y',
p_skip_rows => 1,
p_max_rows => 500,
p_store_profile_to_collection => 'FILE_PARSER_COLLECTION',
p_file_name => f.filename ) ) p
where f.name = :P411_FILE;
BEGIN
OPEN c;
FETCH c INTO v_TAG_NUMBER, V_RECV_QTY;
select i.ident
into dummy_ident_pk
from m_idents i,
m_commodity_codes cc
where cc.commodity_code = V_TAG_NUMBER
and i.commodity_id = cc.commodity_id;
LOOP
EXIT WHEN c%NOTFOUND;
END LOOP;
CLOSE c ;
END;
Best regards.
Christian