> When executing a script, I want to add a table and then use an insert
> statement to add some values. However, my insert statements seem to be
> faling becuase they don't see the newly created tables. How do I make
> the new tables visible? Do I have to somehow update the schema cache?

No, you need to make sure there is a hard commit between the create table
statement and whatever afterwards makes use of the table.

Jason Wharton