C#ÈçºÎµ÷ÓÃoracleÉϵĺ¯Êý£¿

ÎÒÓÃC#µ÷ÓÃoracleÉϵĺ¯Êý£º
CREATE OR REPLACE FUNCTION GetNextRoute(var_sn IN VARCHAR2) RETURN varchar2 
¡£¡£¡£¡£¡£


²»Äܳɹ¦£¬ÏÔʾ£º
ERROR [42000] [Microsoft][ODBC driver for Oracle][Oracle]ORA-00900: invalid SQL statement 


µ«ÊÇÕâ¸öoracleº¯ÊýÔÚoracle sql*plus»·¾³ÊÇ¿ÉÒÔʹÓõģ¬Ó¦¸ÃûÓÐÓï·¨ÉϵĴíÎó£¬ËùÒÔ¿ÉÄÜ»¹ÊÇC#´úÂëûдºÃ¡£

ÎÒµÄC#´úÂëÈçÏ£º
  OdbcCommand cmd = new OdbcCommand();
  cmd.CommandType = CommandType.StoredProcedure;
  cmd.CommandText = "GETNEXTROUTE";
  cmd.Connection = conn;


  OdbcParameter parameter = new OdbcParameter("var_sn", OdbcType.VarChar, 40);
  parameter.Direction = ParameterDirection.Input;
  parameter.Value = tbSN.Text;

  // Add the parameter to the Parameters collection. 
  cmd.Parameters.Add(parameter);

  OdbcParameter parameter1 = new OdbcParameter();
  parameter1.ParameterName = "result";
  parameter1.OdbcType = OdbcType.VarChar;
  parameter1.Direction = ParameterDirection.ReturnValue;
  parameter1.Size = 30;


  // Add the parameter to the P