Home » Other » General » Develop reusable code to call a executable from stored procedure
Develop reusable code to call a executable from stored procedure [message #385312] Mon, 09 February 2009 01:19 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi All,

Can any one please help out me to develop reusable code to call a executable from stored procedure.
This can be achieved using Java Stored Procedure feature of Oracle and I need to this utility by executing sql*loader from stored procedure.

Thank you,

[Updated on: Mon, 09 February 2009 01:26]

Report message to a moderator

Re: Develop reusable code to call a executable from stored procedure [message #385313 is a reply to message #385312] Mon, 09 February 2009 01:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Explain what is your real need, not what you are trying to do.
It is almost ununderstandable and I think it has nothing to do in SQL & PL/SQL forum.

Explain, in what we can help you? Java, SQL*Loader, PL/SQL?
Post what you already tried or thought.
Post what you already searched, found and studied.

Regards
Michel

[Updated on: Mon, 09 February 2009 01:31]

Report message to a moderator

Re: Develop reusable code to call a executable from stored procedure [message #385315 is a reply to message #385312] Mon, 09 February 2009 01:34 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
This might help: http://www.orafaq.com/scripts/plsql/oscmd.txt
Re: Develop reusable code to call a executable from stored procedure [message #385320 is a reply to message #385315] Mon, 09 February 2009 01:40 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

The Main purpose is to
"develop reusable code to call a executable from stored procedure and this utility by executing sql*loader from stored procedure "

Thank you
Re: Develop reusable code to call a executable from stored procedure [message #385321 is a reply to message #385320] Mon, 09 February 2009 01:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And Frank gave you the answer.

Regards
Michel

[Updated on: Mon, 09 February 2009 01:42]

Report message to a moderator

Re: Develop reusable code to call a executable from stored procedure [message #385322 is a reply to message #385321] Mon, 09 February 2009 01:49 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Frank gave me the solution for "Execute operating system commands from PL/SQL".

Thank you,
Re: Develop reusable code to call a executable from stored procedure [message #385328 is a reply to message #385322] Mon, 09 February 2009 02:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And does not "sqlldr" (that is SQL*Loader) an OS command?

Regards
Michel
Re: Develop reusable code to call a executable from stored procedure [message #385709 is a reply to message #385322] Tue, 10 February 2009 13:36 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Look at your previous topic http://www.orafaq.com/forum/m/363102/66800/#msg_363102

Based on all your posts, you do not seem capable of finding anything out for yourself.
Previous Topic: Functional Overview document for "Retail Sales Audit"
Next Topic: oracle 10G upgration (merged)
Goto Forum:
  


Current Time: Sat Dec 03 01:28:46 CST 2016

Total time taken to generate the page: 0.09145 seconds