Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How To Call a Stored Function with Parameters?

April 26, 2017function parameters stored

0

Posted

How To Call a Stored Function with Parameters?

1 Answer

0

Posted

You can define a function that takes parameters, provide values to those parameters when calling the function. Here is a good example of a function with a parameter:SQL> CREATE OR REPLACE FUNCTION GET_DOUBLE(X NUMBER)2 RETURN NUMBER AS3 BEGIN4 RETURN X * 2;5 END;6 /Function created.