Using Apex 4.1.1 on Oracle XE 11G (Linux)
I have a form and a report in and when you click on create button it will clear the cache in page 6 so you can create a new entry.
If click on the link on table which will set the value of
P6_TID (type hidden) with a value, the typical Form & Report setup except I created it manually and was working fine for over a month since creation.
Now when I click on the CREATE button its no longer clearing cache in page 6. Instead it retrieves the latest values I had earlier (P6_TID holding the latest value).
However just earlier I was having another issue where I had to drop the parsing schema and got
ORA-01940 - cannot drop a user that currently logged in, so I had to do a:
SQL> shutdown immediate;
and as soon as Oracle stopped I started it up and created my user, granted necessary permissions and imported the old DMP file.
I've gone through this step many times but only now I am getting the ORA-01940 error. So have no idea if its anything to do with the issue of clearing cache I am having. Both issue coincided same time.
Has anyone had any such problem where they are unable to clear cache for a page or session? I got absolutely know idea what I have to do get it back working.
Cheers.