Jan 23, 2008, 1:50 AM
Post #1 of 2
create table is not allowed with in a multi statement transaction
This is the code I am trying to execute.
my $sth=$dbh->prepare("create table test(id integer)");
And I am getting the error as "create table command is not allowed with in a multi-statement transaction".
But I am not issuing multiple statements and I didn't keep it in a transaction. Then why is is that I am getting this error.
When I searched about this error I came to know that if "ddl in tran" is set to true then this error can be handled. Is there no other solution to this one, like executing as a single statement and not keeping it in a transaction.
Can someone help me out in this.
Thanks in advance.