Hi, I'm using DBI with oracle 9i drivers.I have a script that opens a database handle $dbh and creates a table. A short while later I run an oracle stored procedure that ends up populating this table with schema statistics. This all works fine, but I noticed after some testing that when you have a look at the table creation script that is run by the oracle procedure "dbms_stats.create_stat_table(user, 'STAT_TAB', null)" the script contains thousands of insert statements as well as the table creation statement.
If I run the commands separately in TOAD I don't see this? My guess is that I'll have to disconnect following the table creation statement and reconnect for the other commands, but this doesn't seem the right behaviour to me. I've set AutoCommit => 1, but this made no difference. Does anyone have any ideas how to avoid this, as it would appear a ddl statement is becoming mixed with a dml statement. Thanks, Matt Visit our website at http://www.ubs.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. This message is provided for informational purposes and should not be construed as a solicitation or offer to buy or sell any securities or related financial instruments.
