我已经动态创建了一个表，并从.csv文件写入了数据。我已经在将创建的表名作为参数传递的过程中完成了此操作。现在，我想从该表中读取数据，或者理想情况下，我想以与从数据库内部存储的数据进行比较的相同过程，将该表中的整个数据写入游标或数组。我试图创建动态游标和数组，但是没有用。有什么方法可以实现？

    CREATE OR REPLACE PROCEDURE My_procedure (p_ext_table_name   VARCHAR2,p_file_name        VARCHAR2)
    AS
        v_ext_create   VARCHAR2 (10000);
        v_ext_table_name varchar2(100);
        --emp_refcur   SYS_REFCURSOR;
        --type ext_tab is table of EXT_table%rowtype;
        --emp_tab ext_tab;
    BEGIN
     
     v_ext_table_name := p_ext_table_name;
     v_ext_create :=
     'CREATE TABLE ' || p_ext_table_name || q'! ( 
      CUSTOMER_ID                      NUMber,CUSTOMER_MAILING  CHAR(2 BYTE))
      ORGANIZATION EXTERNAL
      (  TYPE ORACLE_LOADER
         DEFAULT DIRECTORY  MY_DIRECTORY
            accESS PARAMETERS 
           ( RECORDS DELIMITED BY NEWLINE
        FIELDS TERMINATED BY ','
        MISSING FIELD VALUES ARE NULL
        ( Customer_ID,New_Customer_Mailing ))
        LOCATION (MY_DIRECTORY:'!' || p_file_name || q'!')
      )
    REJECT LIMIT UNLIMITED
    PARALLEL ( DEGREE 5 INSTANCES 1 )!';
    
    EXECUTE IMMEDIATE v_ext_create;
    
    
    
    END;

我的想法：

    /*open emp_refcur 'select CUSTOMER_ID from' || v_ext_table_name|| USING CUSTOMER_ID;
    LOOP
        FETCH EMP_REFCUR INTO CUSTOMER_ID;
        EXIT WHEN EMP_REFCUR%NOTFOUND;
        DBMS_OUTPUT.PUT_LINE(CUSTOMER_ID);
    END LOOP;
    CLOSE EMP_REFCUR;*/ didn't work