Is there a way the multiple placeholder substitution, use a parameters instead of multiple sites, such as
The update tpf_revealbaseparams a
The set a.c _jjyzfs=NVL (: 1, c_jjyzfs), a.c _tzmb=NVL (: 2, c_tzmb),
A.c _tzcl=NVL (: 3, c_tzcl), a.c _fxsytz=NVL (: 4, c_fxsytz),
A.c _glrbg=NVL (5, c_glrbg), a.c _tenantcode=NVL (: 6, c_tenantcode),
A.c _tgrbgzgsx=NVL (: 7, c_tgrbgzgsx), a.c _tgrbgtzyz=NVL (: 8, c_tgrbgtzyz),
A.c _tgrbgcwxx=NVL (: 9, c_tgrbgcwxx), a.c _tzgw=NVL (: 10, c_tzgw),
A.c _jjdqrq=NVL (: 11, c_jjdqrq);
The execute immediate v_sql USING p_jjyzfs p_tzmb, p_tzcl, p_fxsytz, p_glrbg,
P_tenantcode p_tgrbgzgsx, p_tgrbgtzyz p_tgrbgcwxx, p_tzgw,
P_jjdqrq;
Achieve similar to define a variable v_usingsql:='p_jjyzfs p_tzmb, p_tzcl, p_fxsytz, p_glrbg,
P_tenantcode p_tgrbgzgsx, p_tgrbgtzyz p_tgrbgcwxx, p_tzgw,
P_jjdqrq ';
Be realized: the execute immediate v_sql USING v_usingsql;
In fact, this doesn't work, a placeholder to YiYiPi in case is not the same value;
Have a great god has what good method can achieve the similar functions,

CodePudding user response:

Does require a few
: N, N parameters on l after using