EBS Customizations (MOSC)

MOSC Banner

Need help passing parameters from concurrent request to procedure

edited Oct 15, 2014 5:38PM in EBS Customizations (MOSC) 4 commentsAnswered ✓

Application version 11.5.10.2 DB version 10g.

I have a concurrent program that has 4 required parameters. The concurrent program calls a SQL*Plus executable. Here's that executable...

DECLARE

  p_errbuf                 VARCHAR2(256);

  p_retcode                VARCHAR2(256);

  p_report_type            VARCHAR2(20);

  p_period_name            VARCHAR2(6);

  p_cad_to_usd_rate        NUMBER;

  p_override_prev_rate     VARCHAR2(3);

BEGIN

schema_name.proc_name(p_errbuf,p_retcode,p_report_type,p_period_name,p_cad_to_usd_rate,p_override_prev_rate);

END;

/

Here's the procedure...

CREATE OR REPLACE schema_name.proc_name (p_errbuf               OUT VARCHAR2,

                                                           p_retcode              OUT VARCHAR2,

                                                           p_report_type              VARCHAR2,

                                                           p_period_name              VARCHAR2,

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