Quote Originally Posted by skoskos
The error message is : ORA-00932...

I cannot find , anyway , what this error implies...
It implies that you are mixing two incompatible datatypes:

ORA-00932 inconsistent datatypes

Quote Originally Posted by skoskos
Thanks ,
but I have tried that out!!!!
You have tried WHAT? You've only showed us what you've tried in the first place, when you've totaly erroneously used bind variables in places where they can't be used. Can you please show us (copy+paste of the actual code and the result together with the complete error messages would do perfectly) what and how you've tried to implement what DaPi has suggested?