DBI table creation script contains insert statements

[sapatos]

Hi, Got a weird one:

Using Oracle 8/9i. connecting via DBI.

1) Create a STAT_TAB table via $dbh->do( "begin dbms_stats.create_stat_table(user, 'STAT_TAB', null); end;" );

2) Later on: $dbh->do( "begin dbms_stats.export_schema_stats(user, 'STAT_TAB',$HighestStatId); end;" );

to populate statistics.

These run perfectly, however when I look at the STAT_TAB table creation script that was generated by statement 1 I can see all the insert statements from statement 2.

I have opened the connection using AutoCommit => 1, (I know statement 1 is DDL but just to be sure), and still get the same.

This does not do any harm but still very weird. Anyone know whats going on. Don't really want to close the $dbh and reopen it just for this. Might have to though.

Appreciate any help or pointers.

Regards,