Oracle: Passing a parameter to a function

Experts,

I have a function that is written poorly.  I have hardcode individual names for each insert query.  I would like to know how to pass a parameter to my function.

attached is the function
Code.txt
Maliki HassaniAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Just add them to the function:
FUNCTION              "SF_NOC_OPERATOR_REPORTING" (d_BEGINDATE_IN DATE, d_ENDDATE_IN DATE, v_REPORTPERIOD_IN VARCHAR2, SOME_NEW_PARAMETER in VARCHAR2)

Then replace the hardcoded variables with SOME_NEW_PARMAETER.
0
 
Maliki HassaniAuthor Commented:
Oh okay!  Let me give that a try...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.