User-1868533221 posted
Hi, I am trying to execute a pl/sql function. And I am having the following error. ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'NR_INSTITUTIONS' ORA-06550: line 1, column 7: PL/SQL: Statement ignored The code in .NET
is: ************************************************************ OracleConnection conn=new OracleConnection ("Data Source= orcl1; User Id=dap; Password=dap;"); OracleCommand cmd=new OracleCommand(); cmd.Connection=conn; cmd.CommandText="institution.nr_institutions";
cmd.CommandType=CommandType.StoredProcedure; cmd.Parameters.Add("instid", OracleType.Number,16).Value=1; cmd.Parameters.Add("num",OracleType.Number).Direction=ParameterDirection.Output; conn.Open(); cmd.ExecuteNonQuery(); td1.InnerText=cmd.Parameters["num"].Value.ToString();
conn.Close(); ************************************************ And the pl/sql Stored Procedure is (The Function is inside the package Instituion. The type of instid is number) ************************************************ function nr_institutions (instid
institutions.inst_id%type) return number is num number; begin select count(*) into num from institutions where ins_inst_id=instid; return num; end nr_institutions; Can anyone tell me why this is happening?? Thanks a lot Arilde
User1392434580 posted
Arilde, Try this command in oracle: desc institutions; that will tell you all of the columns in that table or view and what their datatypes are. From there match the Datatype of the column to the Parameter in .NET, At first glance i'd suspect you've got the
size incorrect, but that's just a guess. Hth, Scott
User-1362986357 posted
I had the same errror message when I added a new field to a view. The solution was to first DROP the existing view and recreate the view with my new field. That corrected my problem. Worth a try if you're still having problems. Geno
