OraFAQ Forum: Server Utilities » Can i use SQLLDR in Procedure..??

Home » RDBMS Server » Server Utilities » Can i use SQLLDR in Procedure..??

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Can i use SQLLDR in Procedure..?? [message #530764]

Thu, 10 November 2011 05:35

manojbe09
Messages: 16
Registered: October 2011
Location: MUMBAI

Junior Member

Hi,

Pls help..

I want to use SQL loader in a procedure..will it be possible to use it in procedure and if yes then how..???

Regards,
Manoj

Report message to a moderator

Re: Can i use SQLLDR in Procedure..?? [message #530765 is a reply to message #530764]

Thu, 10 November 2011 05:38

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What kind of a procedure? An Oracle stored procedure? Operating system's (batch) procedure? If so, which operating system do you use? Something different?

Report message to a moderator

Re: Can i use SQLLDR in Procedure..?? [message #530766 is a reply to message #530765]

Thu, 10 November 2011 05:41

manojbe09
Messages: 16
Registered: October 2011
Location: MUMBAI

Junior Member

Hii,

Thanks for quick reply..
I want to use SQLLDR in Oracle stored procedure.Is it possible..??

Report message to a moderator

Re: Can i use SQLLDR in Procedure..?? [message #530772 is a reply to message #530766]

Thu, 10 November 2011 06:01

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

SQLLDR is an operating system utility; therefore, you might put its call into an operating system's batch file, and then call that file from a stored procedure using DBMS_SCHEDULER package.

However: you'd perhaps rather switch to external tables feature, that allows you access to a CSV file (you'd load by SQL*Loader) directly from (PL/)SQL. There's a drawback, though - the file must reside on a database server (while SQL*Loader works fine with files stored locally, on your computer).

If you could describe what you'd want to do, someone might suggest (virtually) the best approach for your requirement.

Report message to a moderator

Re: Can i use SQLLDR in Procedure..?? [message #530774 is a reply to message #530772]

Thu, 10 November 2011 06:04

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And here's a link to external table.

Regards
Michel

Report message to a moderator

Previous Topic:	Error while import ( impdp )
Next Topic:	SQL loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 21 18:12:44 CST 2025