Oracle apps policy with C# mo_global.set_policy_context

See more:

C#

SQL

Oracle

RDLC

How to allow the policy to use Oracle Views (Applications) before report (RDLC) in Report Viewer.

Something like this:

SELECT AMOUNT_APPLICABLE_TO_DISCOUNT From
AP_INVOICES_V

I need to call this PL/SQL Before Using this select statement:

Begin
mo_global.set_policy_context('S', 90);
End;

so I did this on page load before setting the SQL Data source to the report:

if (!IsPostBack)
{

    db.connectODB();
    OracleCommand ora_cmd = new OracleCommand("mo_global.set_policy_context", db.con);
    ora_cmd.BindByName = true;
    ora_cmd.CommandType = CommandType.StoredProcedure;

    ora_cmd.Parameters.Add("P_ACCESS_MODE", 'S');

    ora_cmd.Parameters.Add("P_ORG_ID", 90);

    ora_cmd.ExecuteNonQuery();
}

But still no data retrieved.