Solved

Oracle: Passing a parameter to a function

Posted on 2012-04-12
2
308 Views
Last Modified: 2012-06-13
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
0
Comment
Question by:Maliki Hassani
2 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 37838039
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
 

Author Comment

by:Maliki Hassani
ID: 37838047
Oh okay!  Let me give that a try...
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
Via a live example, show how to take different types of Oracle backups using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question