Perform a sql statement in a varchar2 type variable in the Oracle's PL block

For example: Create or Replace Procedure SD_GT_JYZ_TJ_TEST (v_flag in varcha2, v_yxnx in varcha2, o_jyztj out number) istmp varchar2 (100): = '';

Begin if v_flag = 'd' Tmp: = 'SELECT Count (*) from b $ comm_table where g3e_id' || v_yxnx; execute immediate tmp into o_JYZTJ; END IF; Exception when Others Then O_JYZTJ: = 0;