Hello,

I mean the commit in a stored procedure.

We have a new project. I should insert some values in more tables and the
client like to see the data in all tables to the same time. We are the LVS,
our partner is the ERP.

How handle this part a procedure? I think, at the moment I insert a new
record in a table, at this moment the record is visible and committed, or
not? But our wish is to show the record first until all data written.

Oh, I should say, the a trigger calls the procedure, not an external
application.

Has everyone an idea in which order takes a procedure a commit for two
inserts in different tables?



Thanks.

Olaf








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