Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bobgillespie
Starting Member
2 Posts |
 Posted - 2004-08-10 : 09:47:45
|
| I creeated dynamic SQL that i would like to execute, but do NOT want it to commit until end of job. I tried to 'set autocommit off', this had no effect. anyone know a way around this?? actual sql...v_sql := 'DELETE ' || upper(tbl_rec.owner) || '.' || upper (tbl_rec.table_name) || ' where ' || tbl_rec.column_name || ' = ' || id_rec.spriden_pidm ;execute immediate v_sql;I thank you all in advance for any assistancebob |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-10 : 10:24:00
|
| Don't double post please.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
execute immediate