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

    Question

  • 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

     

     

     

    Wednesday, December 04, 2013 8:09 AM

Answers