Dear all,
I'm trying to call stored procedure, but I'm having error and I don't know why it's happening…I'm new at this
Here is my code
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
Dim cn As New OracleClient.OracleConnection
cn.ConnectionString = "Data source=orcl; user id= jor; password= jor; Unicode=True"
Dim cmd As New OracleCommand("Gender", cn)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@ayear", OracleType.Number, 10).Value = DropDownList1.SelectedValue
cmd.Parameters.Add("@asem", OracleType.Number, 10).Value = DropDownList2.SelectedValue
Dim da As New OracleDataAdapter(cmd)
Dim ds As New Data.DataSet
cn.Open()
da.Fill(ds)
cn.Close()
GridView1.DataSource = ds
GridView1.DataBind()
End Sub
And here is the procedure
REATE OR REPLACE PROCEDURE Gender (ayear IN Number, asem In Number, totm out number, totf out number)
IS
BEGIN
select Tot_male, tot_female
into totm, totf
from NEWLY_ADM_V_TOT
where adm_year = ayear and adm_sem= asem ;
END Gender;
And I'm getting error
ORA-01036: illegal variable name/number
I appreciate all the help you can give me