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

Hi Steve,
That's also something I tried:) But didn't fix the problem.

Tao
Steve Howard wrote:
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

.