Skip to Main Content

Oracle Forms

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!

question about create_record

635091Dec 15 2009 — edited Dec 16 2009
I'm a newbie with oracle forms. I've read that create_record creates a record and increments the sequence primary key much like nextval does outside of forms. I have two questions.

1) When you execute create_record does it just create a blank record?

2) When you execute create_record how do you retrieve the new sequence key that it created so that you can display it on forms. I've got a form that has a button that says "Generate service request". When the user hits the button I'd like to execute create_record and somehow display the value of the new primary key it created up on the form in a protected field.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 13 2010
Added on Dec 15 2009
7 comments
1,685 views