Calling an Oracle Stored Procedure from a Gridview

Question

Hi I'm trying to do a straight forward call to an Oracle Stored Procedure from a GridView Web Control using UpdateQuery. I created a simple procedure (then tried a package) with no parameters (then with a parameter) and tried to call it from UpdateQuery. I either get a Internal .Net Framework Data Provider error 30 with a parameter or Encountered the symbol UARF_FUNCTIONAL_UPDATE when expecting one of the following: := . ( @ % ; without using a paremeter. My updatequery on the sqldatasource control is: exec uarf_functional_update; I'm sure I'm missing something very simple (syntax or something) but I can't find the right direction in my help material. Any assistance would be greatly appreciated.

Vijaya Kadiyala · Answer

Hi Check out the below link http://www.c-sharpcorner.com/UploadFile/john_charles/CallingOraclestoredproceduresfromMicrosoftdotNET06222007142805PM/CallingOraclestoredproceduresfromMicrosoftdotNET.aspx Thanks -- Vj http://dotnetvj.blogspot.com

Bechir Bejaoui · Answer

I can't detect the problem exactly but never the less this is an entire code of how to call a stored procedure from oracle database: using Oracle.DataAccess.Client; OracleConnection conn = new OracleConnection( Persist Security Info=False;User ID=SCOTT;Password=TIGER;Data Source=MYSERVER;); conn.Open(); OracleCommand cmd = new OracleCommand(ProcedureNameconn); cmd.CommandType = CommandType.StoredProcedure; OracleParameter p aram 1 = new OracleParameter(ParameterNameOracleDbType); p aram 1 .Direction = ParameterDirection.Input; p aram 1 .Value = sCode1; p aram 1 .Parameters.Add( p aram 1 ); . . . . OracleParameter p aram _n = new OracleParameter(ParameterNameOracleDbType); p aram _n .Direction = ParameterDirection.Input; p aram _n .Value = sCode1; cmd.Parameters.Add( p aram _n ); cmd.ExecuteNonQuery(); conn.Close(); hope that helps you