Hi , I am using below code to execute a stored process (view) from oracle but its giving me "access violation" error. proc sql; connect to odbc (dsn = dnsname user=xxxxx pwd=xxxxx); create table schema.table_name (compress = yes) as select * from connection to odbc ( execute schema_name.view_name ); disconnect from odbc; quit;
... View more