Using SAS/ACCESS Interface to Oracle with SAS 9.1, you can create an
Oracle temporary table and insert the values from a SAS data set into
this temporary table using the libname engine. The following code
demonstrates this:

  /* Use PROC SQL Pass-Through to create the Oracle temp table */
  /* Then use libname engine to insert rows from SAS data set, */
  /*   sasuser.TRANS into the Oracle temp table, TEMPTRANS     */

  libname ora oracle user=scott pw=tiger path=lupin connection=global;
  proc sql;
  connect to oracle (user=scott pw=tiger path=lupin connection=global);
   execute (create global temporary table TEMPTRANS
       (empno number, sal number) on commit preserve rows) by oracle;
  insert into ora.TEMPTRANS select * from sasuser.TRANS;
  select * from connection to oracle(select * from temptrans);
  quit;

Operating System and Release Information