I see that Mr. Buchan answered his own question (use dbms_lock inside an insert trigger to wait until the processing is done.) But after reading your question I looked at security policies aka fine-grained access control (dbms_rls) and started wondering, how can the fine-grained access control apply to an insert?
From my trials and from what the documentation says, a security policy will add an extra condition to the end of your where clause. But it also gives you the option to apply the security policy to an insert statement. Has anyone ever done that? If so, how and why?
