PROCEDURE insertA(param in varchar2)
    IS
           v_col VARCHAR2(32000) := 'colA, colB, colC';

           v_ins    VARCHAR2(32000) := 'INSERT INTO '||getU||'.'||My_TABLE||' ('||v_col||') ' || '
                                       (SELECT 'A',
                                        valueB as B,
                                        valueC as C
                                        from table2
                                        where colX = '''||param||''');
    BEGIN
        EXECUTE IMMEDIATE v_ins;
    END;