Oracle does behave like this - actually to the point where you can't add new tables and then run parametrised queries on them within the same session (I believe it is session related).
Databases weren't designed to dynamically updated at runtime, and never have been - so you will end up hitting brick walls there. Mark On 3/6/07, Adam Cameron <[EMAIL PROTECTED]> wrote: > > > > Most database (including SQLServer) presume that the database structure > does > > not change between re-uses of parameterized queries. > > What a strange presumption for them to make! Sure, table-schema > updates are rare compared to table-queries, but it's not like the DB > doesn't *know* when the table gets updated, and accordinly is > completely unprepared for the ramifications of such. So it should be > sensible enough to go "well all those compiled queries that use that > table ambiguously (like the ones with select *)... out the window you > go: you'll have to be recompiled next time". That is better than just > going "err... I have no idea what you're talking about any more [face > plant]". > > Does Oracle behave like this? > > -- > Adam > > > > > -- E: [EMAIL PROTECTED] W: www.compoundtheory.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
