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_at_gmail.com 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
Received on Mon Jul 17 2006 - 16:11:55 CDT