yes this may be the problem. Because on windows OS we r having Oracle 9i(9.2.0) and on Linux we r having oracle 8i.(8.1.7).

and on windows Os the same query is working fine.