OraFAQ Forum: SQL & PL/SQL » can i execute the sqlldr from inside the plsql procedure

Home » SQL & PL/SQL » SQL & PL/SQL » can i execute the sqlldr from inside the plsql procedure

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

can i execute the sqlldr from inside the plsql procedure [message #18915]

Thu, 21 February 2002 01:10

ksr
Messages: 112
Registered: January 2002

Senior Member

Hi,
Can i execute the sqlldr exe from inside a plsql procedure.
if so,how can i do it.

thanks
ksr

Report message to a moderator

Re: can i execute the sqlldr from inside the plsql procedure [message #18920 is a reply to message #18915]

Thu, 21 February 2002 05:32

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

you have to write java stored procedure or external procedures(pro*c program) to call any OS commands .

Report message to a moderator

Re: can i execute the sqlldr from inside the plsql procedure [message #21362 is a reply to message #18915]

Tue, 30 July 2002 03:43

SEMANTICA
Messages: 9
Registered: July 2002

Junior Member

You can use PL/Run to execute any (local or remote) job or process and collect output and error streams. PL/Run allows you to use PL/SQL calls to execute any OS or PL/SQL program through the PLRUN package. You can download a free trial at www.plrun.com.

SEMANTICA

Sales team
www.semantica.com

Report message to a moderator

Previous Topic:	Is it possible to use UTL_FILE.fopen to open a text file from a server that is not the current serve
Next Topic:	Trigger connect to different database?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 19:52:37 CDT 2024