The only problem I see with the approach of stripping out semi-colons before passing DDL statements to Oracle is that CREATE PACKAGE statements have semi-colons all over the place... in fact, you can't have a PACKAGE Specification and body without the semi-colons which terminate each statement in PL/SQL.
Will $dbh->do() cough and gag on that? > One problem you may be facing in your current approach is > the semicolons -- remember they may have to be stripped off > before being > passed to a $dbh->do(), at least some DBDs don't want to see > the semicolons. > > -- > Jeff > >
