Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Passing sequence nextval in insert statement

user640001Aug 10 2010 — edited Aug 10 2010
Hi,

Want to insert a record in table A using incremented sequence value to be get inserted in the ID column of table.

ID column is having a primary key constraint

created sequence test1_seq for that table

How to use this sequence number's NEXTVAL to be get inserted in ID column of table A, along with other data.

How to pass the values to the below procedure for inserting record ?

There are total six fields in the column

execute pk_test1.insert_test1('*How to pass next sequence value here ?*','rec2','rec3','rec4','rec5','rec6')


With Regards

Edited by: user640001 on Aug 10, 2010 12:25 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 7 2010
Added on Aug 10 2010
3 comments
6,217 views