How to get employee details using stored procedure in oracle database

Dibyajyoti Palata

Help me, anyone, I am new in Oracle access in c# asp.net.

using (OracleConnection objConn = new OracleConnection(strConnection)
{
OracleCommand command = new OracleCommand();
command.Connection = objConn;
command.CommandText = "SP_GET_EMPLOYEE_DETAIL";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("VARCALLDATE", OracleDbType.Varchar2).Value = strdate;
command.Parameters.Add("VARUCID1", OracleDbType.Varchar2).Value = CODE1;
command.Parameters.Add("VARUCID2", OracleDbType.Varchar2).Value = CODE2;
command.Parameters.Add("VARUCID3", OracleDbType.Varchar2).Value = CODE3;
command.Parameters.Add("VARUCID4", OracleDbType.Varchar2).Value = CODE4;
command.Parameters.Add("VARUCID5", OracleDbType.Varchar2).Value = CODE5;
try
{
objConn.Open();
command.ExecuteNonQuery();
adapter = new OracleDataAdapter(command);
adapter.Fill(ds);
objConn.Close();
Gridlist.DataSource = ds.Tables[0];
Gridlist.DataBind();
}
catch (Exception ex)
{
System.Console.WriteLine("Exception: {0}", ex.ToString());
}
objConn.Close();
}

ERROR:

{"ORA-06550: line 1, column 7:\nPLS-00306: wrong number or types of arguments in call to 'SP_GET_EMPLOYEE_DETAIL'\nORA-06550: line 1, column 7:\nPL/SQL: Statement ignored"}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nisha Regil6y ago
Accepted answer
1) Please crossverify the number of arguments.
2) Cross check Datatype of arguments passed with that of parameters defined in the procedure.
3) Check if not parameter value passed should not have null value.

Also you can refer to
https://stackoverflow.com/questions/11505204/ora-06550-line-1-column-7-pls-00306-wrong-number-or-types-of-arguments
Ajay Gohil6y ago
Hi

Syntax for creating store procedure. you have to follow syntax for creating and calling storeprocedure.
Error says that you are calling store procedure with inappropriate parameter or wrong data type.so just check it once.

CREATE PROCEDURE procedure_name
(
//parameter
)
AS
BEGIN
//Apply select query
END;

Please refer below site:

https://docs.oracle.com/cd/E28280_01/bi.1111/e16630/app_ds_from_sp.htm#BIRDG629
Jenith Thakkar6y ago
Please provide that sp to check the query

Thank you