Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Calling Oracle stored procedure in C#???

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

From: Steve Howard <stevedhoward_at_gmail.com>
Date: 17 Jul 2006 12:25:32 -0700
Message-ID: <1153164332.393403.197900@35g2000cwc.googlegroups.com> 






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 - 14:25:32 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US