Solved

Oracle: Passing a parameter to a function

Posted on 2012-04-12
2
295 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to recover a database from a user managed backup

744 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now