OLEDB - Multi Org - Setting MOAC - sql problems

JonathanHolstin — Mon, 13 Jan 2020 16:11:00 GMT

Hello,
I'm trying to set my MOAC prior to running my get collection sql. My execute sql MOAC statement is a simple:

"exec apps.mo_global.set_policy_context('S',89)"

Could not execute code stage because exception thrown by code stage: ORA-00900: invalid SQL statement

I've included the above as an execute and then tried it at the top of my get collection sql (with an ; to separate). Does anyone have experience with this? It seems like it should be a straightforward process but I've never attempted it before.

Thanks,
Jon

------------------------------
Jonathan Holstine
Systems Accountant
Interior Business Center
America/Denver
------------------------------

topic OLEDB - Multi Org - Setting MOAC - sql problems in Product Forum

OLEDB - Multi Org - Setting MOAC - sql problems