Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora-00902 invalid data type

247890Jan 4 2009 — edited Jan 5 2009
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.

Comments

713479
Hi,

I resolved it and the solution is once we have install the MS certificate Authority on AD we need to reboot/start the domain controllers in order to propogate the changes and after the restart ldapbind was successful.

Thanks
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 2 2009
Added on Jan 4 2009
30 comments
8,090 views