Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jprealini
Starting Member
2 Posts |
 Posted - 2009-03-18 : 13:46:12
|
| Hi!! First post here...I succesfully connected an Oracle 9i server from SQL 2000 via a linked server... I can even query tables and everything... The only problem is that, for some queries, I need to set NLS_LANGUAGE session parameter (Oracle stuff)When I do it in Oracle (TOAD) I run this:ALTER SESSION SET NLS_LANGUAGE = 'LATIN AMERICAN SPANISH';But I can't find a way to set this parameter before trying to run a query. If anyone know how to do this from Query Analyzer, or from a Stored Procedure, o setting anything anywhere, I would appreciate your helpThanks!!From ArgentinaJP |
|
|
|
|
|
How to set NLS_LANGUAGE in Oracle Linked server