Date:         Tue, 5 Jan 2010 10:51:05 -0500
Reply-To:     michael@bassettconsulting.com
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Michael Davis <michael@BASSETTCONSULTING.COM>
Subject:      Re: Bulk load to oracle
In-Reply-To:  <74666cd1-9de3-42b8-be3b-bad555731be8@a32g2000yqm.googlegroups.com>
Content-Type: text/plain; charset="iso-8859-1"

Hello Chowdary,

Here are the data set options that I use at our
site to bulkload SAS data sets into Oracle:

(BULKLOAD=YES
BL_OPTIONS='ERRORS=899,ROWS=50000')

I typically use a DATA Step
instead of PROC SQL to load SAS data into Oracle but that should matter
all that much.

As an aside, if you have an urgent
problem, consider contacting SAS Tech Support.  I  have gotten
very good help and prompt attention on questions to the SAS/ACCESS -
Oracle queue.

Best wishes to you and everyone else on the SAS-L
list for 2010.

- Michael Davis


On Mon, January
4, 2010 6:04 am, chowdary
<aramakrishna.chowdary@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 ?
>


--
Michael L. Davis
Ambler  PA
E-Mail:  michael.davis@alumni.duke.edu