Forum Stats

  • 3,758,139 Users
  • 2,251,342 Discussions
  • 7,870,059 Comments

Discussions

ora-00902 invalid data type

247890
247890 Member Posts: 420
edited Jan 5, 2009 1:53PM in SQL & PL/SQL
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.
«13

Answers

This discussion has been closed.