Search notes:

SAS: SQL pass through - connect using

With an existing library, a pass through SQL statement can be executed as follows:
%let ora_user     = rene;
%let ora_password = secret_garden;
%let ora_server   = ora.test.renenyffenegger.ch;


libname tq84_ora
   oracle 
   user                     = &ora_user
   password                 = &ora_password
   path                     = &ora_server
   sql_functions            = all
   db_length_semantics_byte = no;


proc sql;
   connect using tq84_ora;

   select * from connection to tq84_ora (
      select   *
      from     all_objects
      where    owner not in ('SYS', 'SYSTEM', 'XDB', 'OUTLN', 'APEX_050000', 'PUBLIC')
      order by owner, object_type, object_name
   );

   disconnect from tq84_ora;
quit;

libname tq84_ora clear;
Github repository about-SAS, path: /programming/proc/sql/connect-using/oracle.sas

See also

proc sql - connect to

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/Companie...', 1746942754, '3.134.95.211', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/Companies-Products/SAS/programming/proc/sql/connect-using/index(65): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78