so i tried google and all that but i just couldnt get it to work. i am using sql developer and i want to find a string in a CLOB field.

when i do this
select charindex('else',colmn)from table;

i get this "function invoked with wrong numer of arguments or types"

any idea?

i appreciate it. thank you a bunch