1 2 3 Previous Next 30 Replies Latest reply on Jan 5, 2009 6:53 PM by Satyaki_De

    ora-00902 invalid data type

    247890
      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 Previous Next