reading oracle sequence numbers

Reply
Regular Contributor
Posts: 167

reading oracle sequence numbers

I am trying to connect to oracle to read the sequence number.

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  ERROR: ORACLE prepare error: ORA-02289: sequence does not exist. SQL statement: SELECT s_id.nextval as seqval from dual

Please help me in this regard

Regular Contributor
Posts: 167

Re: reading oracle sequence numbers

To be more precise , I am trying to read the sequence objects

Ask a Question
Discussion stats
  • 1 reply
  • 275 views
  • 0 likes
  • 1 in conversation