Skip to main content
Question

Set environment variable for ORACLE_HOME at runtime

  • June 2, 2022
  • 1 reply
  • 223 views
killphil84
Participant
Forum|alt.badge.img

I'm working on a system which has Oracle Client 32Bit and 64Bit installed. The environment variable for ORACLE_HOME points to the 64Bit version. I need FME to use the 32Bit Version of the Oracle Client - just for this very FME process. Is it possible to set the environment variable temporarily at runtime (e.g. Phytin Startup Script)? How would this be done?

    1 reply

    redgeographics
    VIP
    Forum|alt.badge.img+63

    You can use a SystemCaller to issue the Set command. Probably 3 times:

    First to find out what the ORACLE_HOME parameter is

    Then to change to what it should be

    Then read/write your data (using FeatureReader and FeatureWriter transformers rather than regular readers and writers

    And finally set it back to what it was.

    FME rocks! \m/

    Community Stats

    32,763
    Posts
    124,240
    Replies
    41,288
    Members
    Terms & ConditionsAccessibility statement
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.