In reply to Shane.

Shane, I'm guessing that you're using the ENCRYPT= data set option. See the cautions/limitations of this in the documentation.

In particular, note that "To copy an encrypted AES data file, the output engine must support AES encryption." If you're copying an encrypted SAS data set to Oracle, that might not work. You might need to decrypt the records you want to copy and then add them to the database. Something like this might work:

proc sql;
create table ora.data as
select * from sas.encrypted(encryptkey=mykey);
quit;