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.

Report message to a moderator

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: 7065
Registered: December 2001
Senior Member
I would use an external table.

MHE

Report message to a moderator

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: 3728
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 12 04:57:32 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.