oracle错误ora-22905,ssrs error : Oracle error ORA-22905: cannot access rows from a non-nested table it...

Oracle error ORA-22905: cannot access rows from a non-nested table item

Creating a report using oracle plsql code .

Getting error ;

Oracle error ORA-22905: cannot access rows from a non-nested table item

when I am trying to pass data in clause in pl sql proc

basically I have a proc which takes 2 parameters(a and b) as input for execution

proc (

P_a varchar2,

p_b varchar2,

OUT SYS_REFCURSOR

)

culprit code

--where  id in (

--    (

--        SELECT * FROM THE (SELECT p_cd_common.get_table_from_string(P_a) FROM dual)

--        union

--        SELECT * FROM THE (SELECT p_cd_common.get_table_from_string(P_b) FROM dual)

--    )

data sample returned from this :SELECT * FROM THE (SELECT p_cd_common.get_table_from_string(P_a) FROM dual)

'Abc','def',

data sample returned from this;SELECT * FROM THE (SELECT p_cd_common.get_table_from_string(P_b) FROM dual)

'fgd','fth',

Any answers ?

How to pass data in clause in a better way