Home » SQL & PL/SQL » SQL & PL/SQL » invoke SQL Loader (9i)
invoke SQL Loader [message #363102] Fri, 05 December 2008 02:14 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi,

I want to invoke/run/call Oracle SQL-Loader Via some Stored Procedure.

I don't want to use Shell Script/Batch files.

Does anyone has any solution for the same.

Thank you.
Re: invoke SQL Loader [message #363111 is a reply to message #363102] Fri, 05 December 2008 02:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I want to invoke/run/call Oracle SQL-Loader Via some Stored Procedure.

External table.

Regards
Michel
Re: invoke SQL Loader [message #363114 is a reply to message #363111] Fri, 05 December 2008 02:37 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Please give me the solution briefly..
Re: invoke SQL Loader [message #363116 is a reply to message #363114] Fri, 05 December 2008 02:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read your other post, you (will soon) know how to create an external table.

Regards
Michel
Re: invoke SQL Loader [message #363120 is a reply to message #363116] Fri, 05 December 2008 02:44 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

I know crating External tables. But from there How to invoke the sql* loader via stored Procedure without using Shellscript/Batch file.

Re: invoke SQL Loader [message #363122 is a reply to message #363120] Fri, 05 December 2008 02:50 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You're missing the point.
Creating an external table is functionally similar to running SQL*Loader, except that everything is controlled from within the database.

If you create an external table pointing to your data file, then you have no need to run Sql Loader, as the data is already available in the database via the external table.
Re: invoke SQL Loader [message #363127 is a reply to message #363122] Fri, 05 December 2008 02:53 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Yes.. But here I want to invoke the SQL* Loader via stored Procedure without using Shell script / Batch files. How it is possible?
Re: invoke SQL Loader [message #363134 is a reply to message #363127] Fri, 05 December 2008 03:17 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
What problem are you trying to solve?

It is possible, although tricky to run SQL*Loader from plsql.
It is easier to create an external table, and both provide the same access to the data.

Why are you determined to use SQL*Loader?
Re: invoke SQL Loader [message #364351 is a reply to message #363102] Mon, 08 December 2008 02:44 Go to previous messageGo to next message
shettypravs
Messages: 9
Registered: August 2008
Junior Member
A reply that was posted to you earlier ---

You need to create a Java stored proc and do it.

1. Create a Java store proc which will execute OS command.
2. Create a Wrapper PL/SQL proc which will call Java stored proc
3. Execute It wherever required.


Hope this will help.

[Updated on: Mon, 08 December 2008 02:49] by Moderator

Report message to a moderator

Re: invoke SQL Loader [message #364354 is a reply to message #364351] Mon, 08 December 2008 02:48 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What have you against external table?

Regards
Michel
Previous Topic: Need help (again) with " ORA-00984: column not allowed here"
Next Topic: how to get the list of tables having referential integrity connection
Goto Forum:
  


Current Time: Fri Dec 02 23:20:41 CST 2016

Total time taken to generate the page: 0.06458 seconds