| invoke SQL Loader [message #363102] |
Fri, 05 December 2008 02:14  |
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 #363120 is a reply to message #363116] |
Fri, 05 December 2008 02:44  |
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 |
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 |
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 |
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 |
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
