You can also use passthrough sql to execute packages on the oracle platform. If you already have a libname defined (say OraLib) for the oracle connection, you can use the new connect using syntax. If not, then you'll need to use the expanded connection syntax. proc sql; connect using OraLIb as OraCon; execute ( exec schema.packagename ) by OraCon; disconnect from OraCon; quit; I haven't tested it...but if your package returns values, then you might could use something like create table work.want as select * from connection to OraCon( exec schema.packagename );
... View more
