Hi,

proc sql;
24         insert into ikd.'IKD$TA_F_PERLE'n (BULKLOAD=YES BL_LOG='/
pkg/moip/tmv824/sas_datamart/sasbin/t2DISK'
24       ! BL_DELETE_DATAFILE=YES OR_PARTITION=P200907)
25            select * from ikdb.loadperle3;
NOTE: 2 rows were inserted into IKD.'IKD$TA_F_PERLE'n.

ERROR: The SQL*Loader utility failed to execute(OS RC=1). Some
possible reasons:
 -SQLLDR not installed.The cmd assumed is "sqlldr". If it is anything
else use BL_SQLLDR_PATH to specify it.
 -SQLLDR may be having trouble creating the log file.Make sure you
have write permission to the dir where the log is
       created(default is current dir) If BL_LOG is specified, make
sure the path specified is a valid one.
 -Remove any double sets of quotes you may be having-keep only one
set.

*********But Sqlldr is being installed
*********And I have write permissions to particula table.

Can Any one solve plz ?

Chowdary,

One possibility is that the log you specified isn't the one you
intended.  Have you tried it using the full path rather than:
'/pkg/moip/tmv824/sas_datamart/sasbin/t2DISK'  ?

Art
------------
On Jan 4, 6:04 am, chowdary <aramakrishna.chowd...@gmail.com> wrote:
> Hi,
>
> proc sql;
> 24         insert into ikd.'IKD$TA_F_PERLE'n (BULKLOAD=YES BL_LOG='/
> pkg/moip/tmv824/sas_datamart/sasbin/t2DISK'
> 24       ! BL_DELETE_DATAFILE=YES OR_PARTITION=P200907)
> 25            select * from ikdb.loadperle3;
> NOTE: 2 rows were inserted into IKD.'IKD$TA_F_PERLE'n.
>
> ERROR: The SQL*Loader utility failed to execute(OS RC=1). Some
> possible reasons:
>  -SQLLDR not installed.The cmd assumed is "sqlldr". If it is anything
> else use BL_SQLLDR_PATH to specify it.
>  -SQLLDR may be having trouble creating the log file.Make sure you
> have write permission to the dir where the log is
>        created(default is current dir) If BL_LOG is specified, make
> sure the path specified is a valid one.
>  -Remove any double sets of quotes you may be having-keep only one
> set.
>
> *********But Sqlldr is being installed
> *********And I have write permissions to particula table.
>
> Can Any one solve plz ?