Jasbinder Singh Bali escribió: > Hi, > I have a Pl/Perlu function in which I have a statement like this: > > ******************* > my $query_tbl_l_header = $dbh->prepare("SELECT > sp_insert_tbl_l_header(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"); > > my $exec_l_from > =$query_tbl_l_header->execute($unmask_id,$from,$to,$sender,$subject,$replyto,$cc,$bcc,$messageid,$inreplyto,$reference,$mversion,$con_type,$con_id,$con_des,$con_enc,$con_length,$con_dis); > *******************
You have a PL/PerlU opening an independent transaction via DBI? That's a bad idea and the explanation to your problem. You should be using SPI instead; there are methods for this in PL/Perl.
-- Alvaro Herrera http://www.advogato.org/person/alvherre "Hay que recordar que la existencia en el cosmos, y particularmente la elaboración de civilizaciones dentro de él no son, por desgracia, nada idílicas" (Ijon Tichy)