Re: dbms_job and SQL LOADER

CrazyIvan wrote:
>
> Is it possible te create a job that launches sql loader ?
>
> I know it is possible to lauch system commands from sql plus using the
> host command, but can this also be used in a job ?
>
> Thanx

Not by default - but you could:

• use dbms_pipes to talk to an waiting C routine
• use external procedures
• use java,

all of which can let you launch an OS command from within the db

hth

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."