Hello Olaf

A transaction can only be finished with a COMMIT or a ROLLBACK.

You can do several operations (insert/delete/update) into a transaction.
These operations will be visible to the current transaction but not to the
other transactions until a COMMIT is executed.

So, in a a stored procedure you can do several inserts, deletes and updates
and all them will be visibles to the user who did the post, but to nobody
else. He/she can insert/delete/update several tables, if like.

After the COMMIT the changes will be public.

Greetings.

Walter.






In other words, if I execute a procedure an insert a record in the first

> table and seconds later with the same procedure (one step and the same
> call)
> it inserts a record in a second table - the first record is only visible if
> the procedure finished? (all steps)
>
> Thank you
>
>
>

[Non-text portions of this message have been removed]