
sudha
New User
Jan 23, 2008, 1:50 AM
Post #1 of 2
(5203 views)
|
create table is not allowed with in a multi statement transaction
|
Can't Post
|
|
hi all, This is the code I am trying to execute. my $sth=$dbh->prepare("create table test(id integer)"); $sth->execute(); 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. --Sudha
|