Hello All,
I need to pass where clause as a dynamic string to the other procedure.
I am having table which has where clause as wo_operation= l_operation_id(i) and language =rec_lan.code
I am having procedure in below manner
TEST(upper('MTH_OPERATIONS_TL'), NULL,' wo_operation ='||l_operation_id(i) ||' and language = '|rec_lan.code ,'INSERT', my_test);
when it generates the sql it gave
select * from MTH_OPERATIONS_TL where wo_operation= 5123 and language =US
Issue is US came like this instead of being in single quotes like 'US'
Can someone please let me know how to pass rec_lan.code so that value comes as 'US'.
Thank you so much