execute independent plsql procedure

[taixut]

Hi all,

I want to be able to call a packaged procedure from another package. I want the called procedure to have an independent session, i.e., it has it's own commit processing,
completely independent of the calling program so the calling program does not wait it to finish.

Thanks on advance.

 

[sem]

Ther's no prebuilt way to call some procedure asynchronously. You may use AUTONOMOUS TRANSACTION, but though the transaction will be separate, your calling session will still wait for its ending. You may use Oracle pipes or queues to pass parameters to some procedure which may be invoked by Oracle job or just from another session.

Regards, Dima