| query view returns no results [message #680484] |
Sat, 16 May 2020 09:12  |
 |
irisa
Messages: 2
Registered: May 2020
|
Junior Member |
|
|
Hello,
Cannot see any view results.
Example:
select * from PA_FIN_PLAN_TYPES_VL;
No rows returned, but is should.
This view is based on PA_FIN_PLAN_TYPES_B and PA_FIN_PLAN_TYPES_TL, for which I can see results.
I am using Oracle SQL Developer and standard user apps.
Please suggest what to look for.
Regards,
irisa
|
|
|
|
|
|
| Re: query view returns no results [message #680486 is a reply to message #680484] |
Sat, 16 May 2020 09:39  |
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
If you look at the source code for the view you'll see that it ends with this,FROM PA_FIN_PLAN_TYPES_TL T
, PA_FIN_PLAN_TYPES_B B
WHERE B.FIN_PLAN_TYPE_ID = T.FIN_PLAN_TYPE_ID
AND T.LANGUAGE = USERENV('LANG')[Updated on: Sat, 16 May 2020 10:02] Report message to a moderator |
|
|
|
| Re: query view returns no results [message #680511 is a reply to message #680486] |
Tue, 19 May 2020 08:39 |
|
irisa
Messages: 2
Registered: May 2020
|
Junior Member |
|
|
Hi John,
PA_FIN_PLAN_TYPES_TL.LANGUAGE = US
SELECT USERENV('LANG') FROM DUAL; -> RO
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Oracle\KEY_DevSuiteHome1\NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
SQL Developer > Tools > Preferences > Database > NLS > all set for AMERICAN / AMERICA
Where else I should check / change?
Thank you,
irisa
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
