Re: Calling Oracle stored procedure in C#???


taohuang.tamu@xxxxxxxxx wrote:
odbcCommand.CommandType = CommandType.StoredProcedure;
odbcCommand.CommandText = "BEGIN myProc(?, ?); END;";
odbcCommand.CommandTimeout = 0;

Hi Tao,

You may want to try using a CALL construct, rather than BEGIN/END, as I
could get this to work...

OdbcCommand odbcCommand = new OdbcCommand("CALL myProc(?,?)",con);
odbcCommand.CommandType = CommandType.StoredProcedure;
odbcCommand.CommandTimeout = 0;

Regards,

Steve

.