I am using ORAOCI 7 stage to read from Oracle 7 table. When i try to import meta data of table, it says Invalid or Unknown NLS Parameter value specified.
When you import a definition and the plug-in selection menu appears you should be able to choose a nls format, maybe you already thought of that, but have you tried to choose another nls format?
it depents on your database, if it is unicode utf-8 or utf-16 is better. i'm using oci9 and also iso8859-1 and i have a database in utf-8, but this is no problem, maybe oci7 likes more precision in the chioce of the nls.
determine what your source database is like
nkln@you wrote:the value for NLS_CHARACTERSET IS WE8IS08859P1, but this character set is not displayed in Datastage.
nkln@you also wrote:I checked the nls_database parameters, the character set is same as specified in datastage.
These seem to contradict each other. Please post your exact NLS_LANG setting from your dsenv file. I would guess it's not quite right. The issue here isn't whether it matches your database or not, that's irrelevant in this context... it's just invalid.
-craig
"You can never have too many knives" -- Logan Nine Fingers
Ok... that seems... fine. Are you setting any other 'NLS' parameters there? Is so, post them - both the variable names and the values you are setting them to, please.
-craig
"You can never have too many knives" -- Logan Nine Fingers