Oracle dynamic sql select while opening ref cursor sys ref cursor Part 8

[@sergeysav6236]

Hi !
Can you help me!
I have two Apex col like :P1_QWER and :P1_QWE
i do dynamic sql :
If :P1_QWER is not null then
sql_stm :=sql_stm || 'select col1, col2 from TABLE where col1 = :P1_QWER and col2 = P1_QWE';
or
if :P1_QWER is null and :P1_QWE is not null then
sql_stm :=sql_stm || 'select col1, col2 from TABLE where col1 = :P1_QWER';
open c1 for sql_stm using ....
how i shold do, if USING :P1_QWER, :P1_QWE i have error not variable is bound?

[@TheSoulamimukherjee]

Hello Sridhar.. Just one doubt , in the bind argument like here its mentioned the value of Job id as IT_PROG . I don't want that. I want it to pass that on runtime. Is that possible? Then how?