topic Re: reading oracle sequence object in SAS Enterprise Guide

reading oracle sequence object

Sheeba — Tue, 09 Apr 2013 23:01:27 GMT

I am trying to connect to oracle to read the sequence object using sas eg.

Please find the code used

proc sql;
connect to oracle as oralib ( path='XXXX' authdomain="XXXX");

create table seq as select * from connection to oralib (

   SELECT s_id.nextval as seqval

      from dual    );

disconnect from oralib;
quit;

I am getting the following error

Please help me in this regard

Re: reading oracle sequence object

Doc_Duke — Wed, 10 Apr 2013 13:08:57 GMT

the error message is missing. Since you are using pass-thru SQL, the error is likely to be an Oracle one and you can go to an Oracle forum to search for it.

Re: reading oracle sequence object

Sheeba — Wed, 10 Apr 2013 23:40:45 GMT

Thank you. It was an oracle error.