Hi,
I use SAS ACCESS interface to Oracle installed on a UNIX server through Enterprise Guide 4.1. When I wanted to create a table in the Oracle database using
-----------------------------------------------------------------------------------------------------------------------------
proc sql;
create table ora_db.person_1 (BULKLOAD=YES BL_OPTIONS='ERRORS=899, LOAD=5000') as
select person_code, first_name, last_name from person_1;
quit;
-----------------------------------------------------------------------------------------------------------------------------
The error message in the log is
--------------------------------------------------------------------------------------
WARNING: Shell escape is not valid in this SAS session.
ERROR: Requested function is not supported.
--------------------------------------------------------------------------------------
Searching the SAS site, I was told that
----------------------------------------------------------------------------------------------------------------------
When you use SAS/ACCESS® Interface to Oracle and you invoke SAS with the -NOXCMD command,
the Oracle bulk loader is automatically disabled and you receive the following error:
WARNING: Shell escape is not valid in this SAS session.
ERROR: Requested function is not supported.
... ... ... ...
----------------------------------------------------------------------------------------------------------------------
How can I enable the bulk uploading function?
Thank you in advance.
myao