Home » RDBMS Server » Server Utilities » Can i use SQLLDR in Procedure..??
Can i use SQLLDR in Procedure..?? [message #530764] Thu, 10 November 2011 05:35 Go to next message
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
Re: Can i use SQLLDR in Procedure..?? [message #530765 is a reply to message #530764] Thu, 10 November 2011 05:38 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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?
Re: Can i use SQLLDR in Procedure..?? [message #530766 is a reply to message #530765] Thu, 10 November 2011 05:41 Go to previous messageGo to next message
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..??
Re: Can i use SQLLDR in Procedure..?? [message #530772 is a reply to message #530766] Thu, 10 November 2011 06:01 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.
Re: Can i use SQLLDR in Procedure..?? [message #530774 is a reply to message #530772] Thu, 10 November 2011 06:04 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And here's a link to external table.

Regards
Michel
Previous Topic: Error while import ( impdp )
Next Topic: SQL loader
Goto Forum:
  


Current Time: Thu Mar 28 07:46:04 CDT 2024