how to run a sql function in pl sql developer
<p>I am new to oracle. I created one function in oracle database using pl sql developer, and I executed successfully. Now I want to run that function from same pl sql developer by query. but it is not working properly. 
Below is my function.</p>

<pre><code>create or replace function com.my_first_test_function(module_code out varchar2,                         
bpm_process_name out varchar2,module_name out varchar2,input in number)return number is
y_return number(1)
N_return varchar(200)
begin
if input='yes' then
Y_return :=select module_code ,bpm_process_name,module_name from com_tm_bpm_process_details;

if input='no' then nested_procedure_exception exception
</code></pre>

<p>but when I try to run this function using below query it is throwing some error message. can any one tell me how to call the function from pl sql developer.</p>

<pre><code>select * from  com.my_first_test_function(java.sql.Types.VARCHAR,java.sql.Types.VARCHAR,java.sql.Types.VARCHAR,'yes')
</code></pre>

<p>here I tried without out parameter values also but still no use.</p>