in reply to Run SQL script which contains multiple line statements
You will have to split up the SQL into separate statements.
DBIx::RunSQL implements a crude approach by splitting the SQL at ;\n mostly.