Desktop productivity for business analysts and programmers

reading oracle sequence object

Accepted Solution Solved
Reply
Regular Contributor
Posts: 158
Accepted Solution

reading oracle sequence object

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


Accepted Solutions
Solution
‎04-10-2013 09:08 AM
Valued Guide
Posts: 2,111

Re: reading oracle sequence object

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


All Replies
Solution
‎04-10-2013 09:08 AM
Valued Guide
Posts: 2,111

Re: reading oracle sequence object

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.

Regular Contributor
Posts: 158

Re: reading oracle sequence object

Thank you. It was an oracle error.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

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