Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Added column, missing from select from...

499072Mar 16 2006 — edited Mar 16 2006
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 13 2006
Added on Mar 16 2006
3 comments
734 views