This content has been marked as final. Show 3 replies
Pl also post the output of this query from the remote database. Does the code manipulate the data in any manner ?
The output when checked in remote database is correct
Output in local database after retrieving data from remote database
Pl elaborate on how you are retrieving the data from the remote database and how you are viewing (what tool) this data. What are the NLS_DATABASE_PARAMETERS values on the remote database ?