----- Forwarded message from [EMAIL PROTECTED] -----
Delivered-To: [EMAIL PROTECTED]
Date: Thu, 30 Jan 2003 13:14:36 +0530
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: DBD::ODBC Transaction Error with Oracle
User-Agent: Internet Messaging Program (IMP) 3.0
X-Originating-IP: 192.168.2.214
Xmilter: ho.netcore.co.in
X-Virus-Scanned: by AMaViS perl-11
Configuration:
Win2K, ActivePerl 5.8, DBD::ODBC meant for 5.8, DBI meant for 5.8
Oracle connection successful.
Insert gives me an error!!
The code and error follows !!
Can u please help me out on this!!
Not able to figure out if it is an ORACLE ERROR or a perl coding Mistake!
my $command = "insert into event_mst (event_mst_id, event_name, table_names,
column_names,
syntax, event_schedule, query) values (event_seq.nextval,
'$name','$tablestring',
'$fieldstring','$mesg', '$event_dur', '$selectquery');";
my $result = $dbh->prepare($command);
$result->execute;
Error returned :
DBD::ODBC::st execute failed: [Oracle][ODBC][Ora]ORA-01456: may not perform
insert/delete/update operation inside a READ ONLY transaction
Sorry for ur time!
Thanks and rgds,
Padmanab Sridhar R.
http://www.netcore.co.in
Mailserv - A Complete Messaging Solution
----- End forwarded message -----
