How to Test Dynamic SQL Using SQL_CURSOR Type

Hello,

How could you test dynamic SQL in which the SQL is returned from a procedure using the SQL_CURSOR type?

Here is an example of the code.

PROCEDURE RETRIEVE_VEHICLE (p_Status IN OUT NUMBER,
                            VEH_MAKE IN OUT SQL_CURSOR)

    IS

        vdynsql VARCHAR2(1000);

    BEGIN

           P_STATUS :=  0;

            vdynsql:='SELECT VEHICLE_MAKE_CD'
                 || 'FROM VEHICLE '
                 || 'WHERE MAKE_FLAG = ''Y''';

        OPEN VEH_MAKE  FOR vdynsql;

    EXCEPTION
      

       WHEN OTHERS THEN
           P_STATUS :=  1;    
    
    END;

Thank you very much!

END;