Ok, Oracle guy here looking for some help.
I have a proc that I wrote to clean up some data.
This compiles and runs but after it completes, the record is still there??? Anyone know what I am missing?
I have a proc that I wrote to clean up some data.
Code:
ALTER PROC maint_rows
@id varchar
AS
BEGIN
BEGIN TRAN
delete maint_table where entityid = @id
COMMIT TRAN
END
This compiles and runs but after it completes, the record is still there??? Anyone know what I am missing?