Oracle Apex - How to execute query generated from a query?

Ah right sorry it was not detailed.

I have an app in apex where I want to add a Process using PLSQL that runs after clicking an Upload button.

The code above returns several insert queries I want to execute during the Process. I am adding that code into PLSQL and now it looks like this:

DECLARE

    l_insert    varchar2(4000);

BEGIN

    WITH cols as (

    SELECT drv.table_name,

        (SELECT listagg(column_name,',') WITHIN GROUP (ORDER BY column_id)

            FROM user_tab_cols

            where table_name = drv.table_name

        ) column_list

    FROM user_tables drv

    where table_name like 'XT%'

    )

    select 'insert into ALL_PORT_OBJS (loadid,xtid,xt,'||column_list||') SELECT &&loadid. , ''&&xtid.'' , '''||lower(table_name)||''','||column_list

        ||' FROM '|| table_name ||';' metasql

        into l_insert

    FROM cols;

    dbms_output.put_line(l_insert);

    return;

END;

Now that it is in PLSQL, I have there the "into l_insert" but this returns ORA-01422: exact fetch returns more than requested number of rows. I think this error is caused by the multiple results it queries but I need to run all those queries and not only one.

Thank you @msammour and @jariola !

I was in the middle of trying a FOR LOOP until I tried to search for this EXECUTE IMMEDIATE. I found the exact solution from http://www.dba-oracle.com/t_oracle_execute_immediate.htm

Thanks so much!

-Jazz