> > > 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 >
Check your Oracle ODBC driver, version and settings. I've tested with 8i and 9i versions of Oracle's ODBC driver. Make sure you do not have read-only checked on the options. Jeff
