BI Publisher (MOSC)

MOSC Banner

Calling Procedure

edited May 15, 2012 1:05AM in BI Publisher (MOSC) 6 commentsAnswered
Hi,
    I have a requirement to schedule calling a procedure in BIP.

    I have a few ques.. Can i call a procedure in BI Publisher ?

    Below is my script to call the oracle seeded procedure.

   "
     DECLARE
     l_parameter_list wf_parameter_list_t;
     BEGIN
     wf_event.AddParameterToList(p_name=>'ECX_TRANSACTION_TYPE',p_value=>'CUSTOM_PO_VENDORS',p_parameterlist=>l_parameter_list);
     wf_event.AddParameterToList(p_name=>'ECX_TRANSACTION_SUBTYPE',p_value=> 'TAX_MASTER_OUT',p_parameterlist=>l_parameter_list);
     wf_event.AddParameterToList(p_name=>'ECX_PARTY_ID',p_value=>'1260',p_parameterlist=>l_parameter_list);
     wf_event.AddParameterToList(p_name=>'ECX_PARTY_SITE_ID',p_value=>'62108',p_parameterlist=>l_parameter_list);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center