You’re offline. This is a read only version of the page.
Announcements
Hello,
I need to be able to insert a row into an Oracle table once my flow has been approved. The table needs a unique key, and that needs to come from a sequence handled in the database. How can I access sequences?
I could query the DBA_SEQUENCES table and then insert an incremented value back, but I would prefer to use the built-in SEQUENCE.NEXTVAL call that oracle has built in.
Thanks!
I was able to setup triggers on the tables I was inserting into. They just look for '-1' and then grab the sequences when that occurs.
Hope that can help someone!
Share
Report
All responses (
Answers (
538
