SAS and SAS/ACCESS does not support BLOB data type. BLOB will be 32K char by default in SAS. So, to load SQL Server and Oracle you have to use native SQL/DB commands. It is possible though to do that through SAS SQL pass-thru syntax using EXECUTE (....) BY ORACLE; But then, you are just using SAS as a DB client for SQL edit and query.
These are quite Oracle specific questions you have. I suggest that you contact any available Oracle DBA/developer at your site to resolve your issue. But not a too wild guess is yes, Oracle probably has to be able to access you input data to be able to store it in the DB.