alternative for name_in() funtion in PLSQL
599569Mar 12 2008 — edited Aug 12 2013HI,
eg :
i having one select statement 'SELECT PARA_SUB_CODE,DECODE FROM PCOM_PARAMETER WHERE PARA_CODE='RES_CODE' AND APP_NO=LV_PARA_1.
througth out my procedure i run the above statement using execute immediate in deferent conditions.
but whenever i am executing the statement i need to replace LV_PARA_1 with the value which stored in local variable LV_PARA_1 at that time.
how i can get the value stored in LV_PARA_1.
that is something like name_in('LV_PARA_1') in forms.
Thanks,