reading oracle sequence object

[Sheeba]

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

[Doc_Duke · Accepted solution]

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.

[Sheeba]

Thank you. It was an oracle error.