| apex report error: ORA-01403: no data found [message #508989] |
Wed, 25 May 2011 08:54  |
wucis
Messages: 60
Registered: March 2005
|
Member |
|
|
Hello,
I added a column to a table, where I have an SQL-report from of the form SELECT * FROM MYTABLE.
Now I get the error ORA-01403: no data found.
I know that I have to go to the report definition and just press the button to apply changes.
Is there another solution ? Cause I have done this as the developer of the application. What about normal users ?
I think this is a browser cache problem but do not know how to solve it.
Even if I apply the changes to a reports sql-definition as developer, and then restart browser and login to the application as "normal apex user" the error ORA-01403: no data found appears.
Thx in advance
[Updated on: Wed, 25 May 2011 09:47] Report message to a moderator |
|
|
|
|
|
| Re: apex report error: ORA-01403: no data found [message #509088 is a reply to message #509074] |
Thu, 26 May 2011 00:09  |
c_stenersen
Messages: 255
Registered: August 2007
|
Senior Member |
|
|
Quote:Adding a column has nothing to do with NO DATA FOUND
Not normally, no. But I can confirm that in this case I experience the same behavior in an ApEx report with "select *" when I add a column to the table. So ApEx is doing something in the background when showing this report which would raise this error.
But when you do the apply changes as OP describes the error disappears. You doing this as the developer should change the report for all users. I was not here able to see any difference for me as a developer and as a normal user when doing a small test case.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
