DATA Step, Macro, Functions and more

Oracle: Obtaining the nextval of a field during a bulkload

Reply
Contributor
Posts: 55

Oracle: Obtaining the nextval of a field during a bulkload

I'm familiar with obtaining the nextval of a Oracle column from DUAL with simple select statements. The technique is slow for high volume batch processing.

Does anybody know the SAS syntax for doing an Oracle bulkload with a column obtaining it's nextval during the bulkload?
Super Contributor
Super Contributor
Posts: 3,174

Re: Oracle: Obtaining the nextval of a field during a bulkload

The SAS support http://support.sas.com/ website link below mentions this topic post:

V6-ACCESS-3960
ORACLE pseudo columns cannot be inserted into ORACLE table
http://support.sas.com/techsup/unotes/V6/3/3960.html


Scott Barry
SBBWorks, Inc.
Ask a Question
Discussion stats
  • 1 reply
  • 197 views
  • 0 likes
  • 2 in conversation