Thank you for your reply..

It might be the problem of collation.

because thats the one I did additionally in main sql server.

The collation of main sql server was SQL_Latin1_General_CP1_CI_AS

And i have...

i am calling stored procedure using Operating system command.

It was working with intermediate server

Thank you for your reply..

We were using to import from another intermediate sqlserver and it was successfull.

And more over i cannot change anything in oracle database which is live.

The issue...