Skip to Main Content

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!

User defined function in where IN clause

1D10TJul 17 2013 — edited Jul 24 2013

Hi,

I have a Function who returns in priview:

(1,2,3,4)

Now i am using this function in SQL where clause

Select from debug where id in debug.debug_process()

On execute select i am getiing ORA-01722 invalid number , i understand that functions return not only numbers but  character symbols too '(,)'

Are it posible to use user defined function who do not return NUMBER in Where clause IN statement ?  If not what tips can sugest me for getting list of values for use in IN Clause?

ID.

Thanks!

This post has been answered by Billy Verreynne on Jul 17 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 21 2013
Added on Jul 17 2013
20 comments
2,041 views