Added column, missing from select from...
499072Mar 16 2006 — edited Mar 16 2006I have a table in my Oracle database. I created the table from SQL Plus, while logged in as user "XF_ADMIN"
I could select and insert from SQL Plus, and could select and insert from my web application (via ODBC).
This morning, while logged in to SQL Plus as "XF_ADMIN" I added a column to this table (and ran "commit"). The column is a simple VARCHAR2(512). I can query the whole table (including the new column) from SQL Plus, and I can see the whole table (including the new column) in the web-based Oracle EM.
BUT, when I query from my web application (which uses the "XF_ADMIN" user), I can still query the table, but the new column is not there. I even printed all the fields in the recordset to my web page, and every column except for the new one I added was displayed.
Can any of you Oracle gurus figure out why this would happen. I have a decent amount of database and SQL experience but my Oracle-specific experience is limited (but growing fast).
Thanks everyone. I've spent the last five hours researching this issue and am anxious to hear what you guys/gals know.
-Brandon