<div>
Parameters are comma separated:<br />
MyFunction (param1, param2)<br />
<br />
If one of the parameters is the result of function2, so be it:<br />
myfunction(nvl(Function2(a<wbr />.Col1),' '),'someotherparam')<br />
<br />
From the description I do not understand what you are asking.
</div>


Parameters are comma separated:
MyFunction (param1, param2)

If one of the parameters is the result of function2, so be it:
myfunction(nvl(Function2(a.Col1),' '),'someotherparam')

From the description I do not understand what you are asking.

<div>
<div class="content wysiwyg-content">
I have a function named MyFunction<br />
<br />
MyFunction has two input parameters.<br />
<br />
A working SQL call to a function named Function2 with one parameter exists.<br />
<br />
MyFunction has 2 parameters instead of 1.<br />
a.Col1, b.Col1<br />
<br />
nvl(Function2(a.Col1),' ') AS myComments,<br />
<br />
What is the syntax for 2 parameters?<br />
<br />
nvl(MyFunction(a.Col1),' ',???) AS myComments,<br />
<br />
??? MyFunction(b.Col1)<br />
<br />
Thanks
</div>
</div>


I have a function named MyFunction

MyFunction has two input parameters.

A working SQL call to a function named Function2 with one parameter exists.

MyFunction has 2 parameters instead of 1.
a.Col1, b.Col1

nvl(Function2(a.Col1),' ') AS myComments,

What is the syntax for 2 parameters?

nvl(MyFunction(a.Col1),' ',???) AS myComments,

??? MyFunction(b.Col1)

Thanks

Oracle - Calling a parameterized function in a SQL Statement

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.