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
------------------------------
