Home » SQL & PL/SQL » SQL & PL/SQL » How to call SQLLDR (sql*loader)from oracle stored procedure?
icon14.gif  How to call SQLLDR (sql*loader)from oracle stored procedure? [message #247829] Wed, 27 June 2007 05:50 Go to next message
fortunethiyagu
Messages: 94
Registered: December 2006
Member

Hi,

How to call SQLLDR (sql*loader)from oracle stored procedure?

Thanx in advance.
Re: How to call SQLLDR (sql*loader)from oracle stored procedure? [message #247831 is a reply to message #247829] Wed, 27 June 2007 05:52 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
I would use an external table.

MHE
Re: How to call SQLLDR (sql*loader)from oracle stored procedure? [message #248053 is a reply to message #247831] Wed, 27 June 2007 21:51 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Maaher wrote on Wed, 27 June 2007 20:52
I would use an external table.

MHE

I would too.

But should you choose to ignore this excellent advice, OS commands can be called using DBMS_SCHEDULER in 10g, or with external C or Java functions in earlier versions.

Both are reasonably advanced techniques that you should not attempt without permission and support from a skilled DBA (who has to then support the monster that you create).

Ross Leishman
Previous Topic: how to convert columns to rows in SQL * PLUS
Next Topic: pl/sql tuning
Goto Forum:
  


Current Time: Tue Dec 06 12:10:45 CST 2016

Total time taken to generate the page: 0.06134 seconds