How to call the oracle stored procedure from VB.NET

See more:

VB

ASP.NET

hi I created a procedure for select in oracle and it will work fine in the backend
itself .but when i call it in vb.net it will display an error message like this

PLS-00306: wrong number or types of arguments in call to 'PLP_MYAPP_SELECT1' ORA-06550: line 1, column 7: PL/SQL: Statement ignored

my procedure is

create or replace procedure plp_myapp_select1(my_flag in varchar2, p_userid in user_master.user_id%type,userid_out out varchar2,p_panno in OTC_REGISTRAION.PANNUMBER%type,panid_out out sys_refcursor,company_out out varchar2)
is
v_id varchar2(40);
begin
if my_flag = 'username' then
select user_id into userid_out from user_master where user_id=p_userid;
dbms_output.put_line(v_id);
elsif my_flag = 'validatepan' then
open panid_out for select pannumber from OTC_REGISTRAION where pannumber =p_panno;
elsif my_flag = 'companyname' then
select companyname into company_out from OTC_INS_COMPANY;
end if;
end;


and in vb.net i am calling the procedure like this


cmd.Connection = cn
cmd.CommandType = Data.CommandType.StoredProcedure

cmd.CommandText = "plp_myapp_select1"
Dim Flag As New OracleParameter("my_flag", OracleDbType.Varchar2)
Flag.Direction = ParameterDirection.Input
Flag.Size = 50
Flag.Value = "username"
cmd.Parameters.Add(Flag)

  Dim qrySerial As New OracleParameter("p_userid", OracleDbType.Varchar2)
        qrySerial.Direction = ParameterDirection.Input
        qrySerial.Value = user_id.ToUpper
        cmd.Parameters.Add(qrySerial)
        Dim OutPut As New OracleParameter("userid_out", OracleDbType.Varchar2)
        OutPut.Direction = ParameterDirection.Output
        OutPut.Size = 400
        'cmd1.Parameters.Add(OutPut)
        cmd.Parameters.Add(OutPut)
       
        Dim result As Integer = cmd.ExecuteNonQuery()
        ada = New OracleDataAdapter(cmd)
        ada.Fill(ds)

what exactly wrong with my coding .if anyaone have ideas just give some inputs

What I have tried:

i tried to call this procedure from vb.net .in the back end it's working fine