OraFAQ Forum: General » Develop reusable code to call a executable from stored procedure

Home » Other » General » Develop reusable code to call a executable from stored procedure

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

Develop reusable code to call a executable from stored procedure [message #385312]

Mon, 09 February 2009 01:19

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

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

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

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

This might help: http://www.orafaq.com/scripts/plsql/oscmd.txt

Report message to a moderator

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

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

Report message to a moderator

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

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

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

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,

Report message to a moderator

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

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

Senior Member
Account Moderator

And does not "sqlldr" (that is SQL*Loader) an OS command?

Regards
Michel

Report message to a moderator

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

joy_division
Messages: 4963
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.

Report message to a moderator

Previous Topic:	Functional Overview document for "Retail Sales Audit"
Next Topic:	oracle 10G upgration (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 19:39:16 CST 2024