EBS Customizations (MOSC)

MOSC Banner

use a function with two parameters in default value

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