sqlldr from pl/sql?

[Scunningham99]

Morning

Is it possible to kick off sqlldr from pl/sql?

Any help would be greatlt appreciated!!



Sy UK

 

[pbopbo]

One way I think is to write a Java stored procedure that calls sqlldr (something like

Runtime.getRuntime.exec(cmd);

. You can than call the java stored procedure in pl/sql like another pl/sql function/procedure.

Hope it helps.

Philippe

 

[LKBrwnDBA]

Create table defined as EXTERNAL on the sql loader file!




----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb