OLEDB - Setting MOAC Connection

JonathanHolstin — Wed, 08 Jan 2020 20:45: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
------------------------------

RE: OLEDB - Setting MOAC Connection

james.roberts.bp — Thu, 30 Jan 2020 10:18:00 GMT

Hi Jonathan,

If you are using the "Data - OLEDB" VBO to perform this action, then unfortunately it does not currently support the execution of SQL stored procedures.

Further details on this, including an alternative approach can be found in the following article:

Why cant I run a stored procedure using Data - OLEDB?

------------------------------
James Roberts
------------------------------

topic RE: OLEDB - Setting MOAC Connection in Product Forum

OLEDB - Setting MOAC Connection

RE: OLEDB - Setting MOAC Connection