Hi Ricardo,

Thanks for scripts, but its pure Shell scripting write. My case is
little different. I will get particular table name and Target database
details. On based on that I need to transfer data to target location,
from Local procedure in oracle I need to do all these process by using
SqlLoader (I need invoke SQL Loader command from Procedure).

Is there any way to handle this?

Thanks,
Chandu
-----Original Message-----
From: Ricardo Chaves
[mailto:oracledba-ezmlmshield-x17736109.[Email address protected]
Sent: Thursday, April 03, 2008 12:46 PM
To: LazyDBA Discussion
Subject: RE: SQLLoader from Procedure

Try to create a shell-script in Unix that will check if a file exists
and
then start sql-loader... can be scheduled in the CRONTAB. Something like
this:

#!/bin/sh
function LoadFile
{
# Start SQL loader

sqlldr userid=user/passwd \
control=$CNTL_FILE \
data=$DATA_DIR/$1 \
log=$LOG_DIR/$1.log \
bad=$BAD_DIR/$1.bad \
discard=$DSC_DIR/$1.dis \
rows=100000 >> $vLogFile
trc=$?

return 0;
}
########### Here it starts ###########
filetypes=`cat $FILE_DIR/cmafiles.lis`

for currtype in $filetypes
do
LoadFile $currtype
rm $FILE_DIR/$currtype
done


Ciao

-----Mensaje original-----
De: chandrashekar
Enviado el: martes, 01 de abril de 2008 16:41
Para: LazyDBA Discussion
Asunto: RE: SQLLoader from Procedure



Hi Oracle Gurus,

Can any one help me on below issue? I want execute SQL Loader command
from procedure. I tried RUN, $ and HOST commands in SQLPLUS window its
working but I am unable to execute same from procedure.

I am desperately waiting for your suggestions.

Thanks,
Chandu

-----Original Message-----
From: Chandrashekar N
Sent: Tuesday, April 01, 2008 11:11 AM
To: 'LazyDBA Discussion'
Subject: SQLLoader from Procedure

Hi All,

Can any one tell me how can I Execute SQL Loader Command from Oracle
Procedure?

Thanks,
Chandu


No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.5/1356 - Release Date:
02/04/2008
16:14




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



***********************
No virus was detected in the attachment no filename

Your mail has been scanned by InterScan.
***********-***********


*********************************************************************************************************************************************************************
"This message and any attachments are solely for the intended recipient and may contain Birlasoft confidential or privileged information. If you are not the intended recipient,any disclosure,copying, use, or distribution of the information included in this message and any attachments is
prohibited. If you have received this communication in error, please notify us by reply e-mail at ([Email address protected] and permanently delete this message and any attachments. Thank you."
*********************************************************************************************************************************************************************

Oracle LazyDBA home page