ORACLE ERROR Unable to read list of values [message #477130] |
Tue, 28 September 2010 23:06 |
rkgoyal98
Messages: 39 Registered: October 2009
|
Member |
|
|
Hello,
We have recently shifted our database from 10G to 11G and after the intial hickups most of the thinghs have stablised. We had changed system by Alter System command so that database does not have case sensevity problem and with that all the reports from the forams have also stabilied
However some of the forms are failing with the above error
ORACLE ERROR Unable to read list of values
These form are running fine with users having DBA privelege. However other users this is failing.
We have also checked that with users not having DBA privelege we are able to read the data in the table within the form also.
The query in the record group is very simple
"SELECT CODE,SHORTDESC FROM GENCODES WHERE CODETYPE='BS' AND CODE <> '00'"
All these forms were fine previously when database was on 10g.
Moreover there are many other fields where list of values are there and allthose are ruing fine.
I have also checked datatype and length in query as well as fields on the form
Kindly tell me how can i resolve this
Regards
|
|
|
|
|
|
|
|