BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Sheeba
Lapis Lazuli | Level 10

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

1 ACCEPTED SOLUTION

Accepted Solutions
Doc_Duke
Rhodochrosite | Level 12

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.

View solution in original post

2 REPLIES 2
Doc_Duke
Rhodochrosite | Level 12

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
Lapis Lazuli | Level 10

Thank you. It was an oracle error.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1926 views
  • 0 likes
  • 2 in conversation