SQL *Loader: Scripting Language???

All,

Just need confirmation from anyone experienced with SQL *Loader: is this utility a kind of scripting language tool, like the one in AWK, PERL, Tcl? Is this application callable from other application?

Basically, I am planning of implementing the following scenario: 1. Oracle Database Server, supplied with SQL *Loader utility. 2. Develop Application server, acting as receving mail server, which will then parse, process and keep any data/document it receives. The document should follow a certain format to be identified as valid ones. The same application will then call SQL *Loader utility to start loading the valid documents into DB then trap any messages it (SQL *Loader) results. This message will be sent back to original document sender for further actions.
3. Presentation Server, could be developed or configured using any available tools (Lotus Notes, RAD tools (VB, etc))

The reason I used mail system as the core infrastructure is because we're planning to integrate a lot of sites, which many of them does not have a good link to central site (where database will reside).

Need comment on the above.

Thanks in advace,

-AS-

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 22 2000 - 21:15:21 CST