Thanks for the reply. I got the result. Immediately after creating the table and inserting the records I was trying to access it. Tried to execute the same program after 10 min and got the result.
Don't know may be cache refresh may took time.
No, the only thing would be that you forgot to commit your changes after inserting the records (although I do not know if XE supports transactions). Depending on your settings, it is then possible that they are (auto)committed when you leave the program that inserts those records.
Joined: Nov 02, 2009
Yes.. i forgot to commit.. i tried to access the records with out committing the changes ,it did not work. when i tried the same after committing the changes it worked. Thanks.