nikil shar wrote:thanks for moving this to the correct forum.
could this have anything to do with the version of oracle driver i am using ?? my version is 9.2
Can you update your db with the above sql?
Test your sql outside of your coding environment and report back...