1
When I add rows thru oracle sqlplus, it does not show the data in APEX. Im using Oracle XE for linux?
I am trying to build a php page which uses oracle db. When I query using php, it doesn’t show any results. But when I use sqlplus, it shows results. Please help!
My best guess is you did not do a commit after inserting your rows. Your apex session will be a different session from your sqlplus session and thus cannot see these rows till you commit them. To be sure you commited, either do a commit in sqlplus, or open up a second sqlplus session and try to see the rows.
My second guess is your apex session is looking at a different data object than your sqlplus session. Thus even though you may have committed the data, your apex session won’t see it because it is looking in the wrong place. Maybe you are logged into a different user or database, or your apex object has a different name.
Good luck, Kevin
Was this answer helpful?
LikeDislike