OLEDB - Setting MOAC Connection

[JonathanHolstin]

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

[jamesroberts]

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