<div>
Do you mean this?<br />
i am calling this function myfunc in another function and storing the returned value in the NUMBER variable.<br />
<br />
v_ret NUMBER;<br />
v_ret := myfunc();<br />
<br />
In this case what will happen?
</div>


Do you mean this?
i am calling this function myfunc in another function and storing the returned value in the NUMBER variable.

v_ret NUMBER;
v_ret := myfunc();

In this case what will happen?

<div>
A penalty grade is not appropriate here, I've requested moderator review
</div>


A penalty grade is not appropriate here, I've requested moderator review

<div>
split among the 3 expert comments
</div>


<div>
<div class="content wysiwyg-content">
create FUNCTION myfunc<br />
return VARCHAR2<br />
is<br />
v_ret NUMBER;<br />
BEGIN<br />
-- functionality which sets v_ret to -1 or (1/2/4/8)<br />
return v_ret;<br />
END myfunc;<br />
<br />
My question is this v_ret will be converted to VARCHAR2 ? Will this create any issues in runtime.?
</div>
</div>


create FUNCTION myfunc
return VARCHAR2
is
v_ret NUMBER;
BEGIN
-- functionality which sets v_ret to -1 or (1/2/4/8)
return v_ret;
END myfunc;

My question is this v_ret will be converted to VARCHAR2 ? Will this create any issues in runtime.?

returning different datatype from a function Oracle PL/SQL

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.