https://communities.sas.com/t5/SAS-Programming/Oracle-Obtaining-the-nextval-of-a-field-during-a-bulkload/m-p/26761#M4800 The SAS support <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> website link below mentions this topic post:<BR /> <BR /> V6-ACCESS-3960 <BR /> ORACLE pseudo columns cannot be inserted into ORACLE table <BR /> <A href="http://support.sas.com/techsup/unotes/V6/3/3960.html" target="_blank">http://support.sas.com/techsup/unotes/V6/3/3960.html</A><BR /> <BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Mon, 04 May 2009 19:54:04 GMT sbb 2009-05-04T19:54:04Z https://communities.sas.com/t5/SAS-Programming/Oracle-Obtaining-the-nextval-of-a-field-during-a-bulkload/m-p/26760#M4799 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.<BR /> <BR /> Does anybody know the SAS syntax for doing an Oracle bulkload with a column obtaining it's nextval during the bulkload? Mon, 04 May 2009 13:50:39 GMT https://communities.sas.com/t5/SAS-Programming/Oracle-Obtaining-the-nextval-of-a-field-during-a-bulkload/m-p/26760#M4799 JMarkW 2009-05-04T13:50:39Z https://communities.sas.com/t5/SAS-Programming/Oracle-Obtaining-the-nextval-of-a-field-during-a-bulkload/m-p/26761#M4800 The SAS support <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> website link below mentions this topic post:<BR /> <BR /> V6-ACCESS-3960 <BR /> ORACLE pseudo columns cannot be inserted into ORACLE table <BR /> <A href="http://support.sas.com/techsup/unotes/V6/3/3960.html" target="_blank">http://support.sas.com/techsup/unotes/V6/3/3960.html</A><BR /> <BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Mon, 04 May 2009 19:54:04 GMT https://communities.sas.com/t5/SAS-Programming/Oracle-Obtaining-the-nextval-of-a-field-during-a-bulkload/m-p/26761#M4800 sbb 2009-05-04T19:54:04Z