Subject | getting sequence val before insert |
---|---|
Author | Ronan van Riet |
Post date | 2004-01-10T13:51Z |
Hello,
I am using an SP to INSERT a record. One of the output params in the SP is
the row_id that will be used for the to-be-inserted record.
For now I am using O_ROW_ID= GEN_ID(GEN_E_PROJECT_ROW_ID, 1)-1;
to get the right row_id.
What is the preferred way of doing this?
Thanks,
Ronan
I am using an SP to INSERT a record. One of the output params in the SP is
the row_id that will be used for the to-be-inserted record.
For now I am using O_ROW_ID= GEN_ID(GEN_E_PROJECT_ROW_ID, 1)-1;
to get the right row_id.
What is the preferred way of doing this?
Thanks,
Ronan