Skip to content

Writing a custom Event that inserts a new row into a table (like RESERVED_LOT_BATCH_TAB) needs to generate a proper rowkey for that new row — which API or function should be used to generate it?

Answer

Use Oracle's built-in sys_guid() function directly: rowkey := sys_guid(); — this generates a properly-formatted unique identifier suitable for use as the row's rowkey when inserting via custom PL/SQL, matching the same underlying mechanism IFS's own generated code uses for rowkey generation.

← Browse Developer Studio, deployment, and upgrades questions