Core Concurrent Processing - EBS (MOSC)

MOSC Banner

how to use a function with two parameters in parameter sql statement

edited Feb 17, 2023 1:50PM in Core Concurrent Processing - EBS (MOSC) 1 commentAnswered

how can I set the second bind parameter to null.

I have tried select bolinf.XXPA_RPT_PROJNUM_PKG.get_selected_list(:$FLEX$.XXPA_PW_PROJECT_NUMBERS, nvl(:$FLEX$.XXPA_PW_PROJECTS_NUM, NULL)) from dual;

bolinf.XXPA_RPT_PROJNUM_PKG.get_selected_list(:$FLEX$.XXPA_PW_PROJECT_NUMBERS, :$FLEX$.XXPA_PW_PROJECTS_NUM DEFAULT NULL) from dual;

neither works for the function

bolinf.XXPA_RPT_PROJNUM_PKG.get_selected_list(:$FLEX$.XXPA_PW_PROJECT_NUMBERS, NULL) from dual this works but I need it to be a variable.

It works fine in sql developer but not in EBS R12

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