CrystalProgDev
Programmer
I have a function with a parameter. I need to pass multiple values to single parameter.
example parameter value 'A,B,C' in sql it has to be IN ('A','B','C').
Can any one please provide me the solution
FUNCTION MTO_ENG104_PIPELINED (str VARCHAR2)
RETURN WBS_TAB
PIPELINED
IS
PRAGMA AUTONOMOUS_TRANSACTION;
CURSOR WBS_CUR_B
IS
SELECT * from table_nn where strval in (str)
...
example parameter value 'A,B,C' in sql it has to be IN ('A','B','C').
Can any one please provide me the solution
FUNCTION MTO_ENG104_PIPELINED (str VARCHAR2)
RETURN WBS_TAB
PIPELINED
IS
PRAGMA AUTONOMOUS_TRANSACTION;
CURSOR WBS_CUR_B
IS
SELECT * from table_nn where strval in (str)
...