ora-00902 invalid data type

    Hello all -

    I have a function that returns a ref cursor.

    When I test this function using PL/SQL developer, it works just fine and returns ref cursor with a set of price values for a set of products.

    However, when I test the same function from SQL*Plus, it errors out.

    select get_price('0123','p1,p2,p3') from dual;

    Error at line 1:
    ORA-00902: invalid datatype

    Could you please help me out. Thanks in advance.
      1 2 3 上一个 下一个