Hello all,
I have a procedure where I select some data, and in the WHERE clause, instead of hard-coding the search criterium like this:
... where custno = p_custno and
tests_done like '%01%';
I would like to pass a varchar2 variable like this:
... p_test := '01';
... exec my_proc(p_custno, p_test);
and then in the procedure:
... where custno = p_custno and
tests_done like '%||p_test||%';
But it doesn't seem to be working. What am I doing wrong?
Thank you.