Hello,

our system has to import CSV data once a night automatically using SQL*Loader. Afterwards these date has to be analyzed.

The first I though to have 2 daemons, a first one running on the DB host who starts SQL*Loader, and a second one running in a different application host who starts the analyzer application. But in this way I can't synchronize both daemons to start the 2nd when the 1st finishes.

Indeed I wish the analizer daemon self started SQL*Loader, thus having only one daemon on the application host, which calls a Stored Procedure who starts SQL*Loader. But I don't know how to.

How can I invoke OS statements from a stored procedure?

Many thanks in advance