reading oracle sequence numbers

Regular Contributor
Posts: 181

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;

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: 181

Re: reading oracle sequence numbers

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

Ask a Question
Discussion stats
  • 1 reply
  • 1 in conversation