I need to insert two records into a Oracle DB, which are linked via object id's which are generated from a sequence. So, the code would be: Create Record1 Set Record1.Id = some sequence Create Record2 Record2.Link = Record1.Id But, once I have created record1 how do I know which record was created, or with which sequence? Please help. email@example.com
posted 16 years ago
Can you just run a SELECT statement to get the sequence number and store it in a variable for later use? long sequenceNum = 0; ResultSet rs = Statement.executeQuery("select sequence_name.nextval from dual"); if (rs.next() ) sequenceNum = rs.getLong(1); Brian
Look ma! I'm selling my stuff!
the new thread boost feature: great for the advertiser and smooth for the coderanch user