SQLTags with Oracle

General Discussion
1

In order to get SQLTags working with Oracle, it is necessary to edit the Driver settings in order to specify a custom key retrieval function.

To do this (assuming that you’ve already installed the oracle driver into FactoryPMI):

  1. Log into the FactoryPMI gateway, click on “Drivers”, and then edit the Oracle driver

  2. Set the following:
    Supports Returning Auto-generated Keys? FALSE
    Fetch Key Query: SELECT ${table_name}_SEQUENCE.CURRVAL from dual

  3. Apply, and restart the server (a soft restart from the link is sufficient). With FactorySQL also configured for the database, you should now be able to use SQLTags in FactoryPMI.