How to call Package in Oracle

Many times BPMC needs to execute oracle package as a part of the source data.

Below is an example syntax.

exec ('Call APPS.PKG_NAME.GL_Balance_to_OLS_Actuals(''?PERIODYEAR?PERIODMONTH'', '''')') AT OrclDB

Note:-

1 - You will need to have a linked setver in SQL 2008 for Oracle.
2 - "PKG_NAME" can be anything e.g "GL_PKG"
3 - ?PERIODYEAR?PERIODMONTH are the values being passed from DPC.