Ejecutar un SP con parametro

SAP Business One
1

Estoy intentando ejecutar un SP con un parámetro, sin embargo no me funciona. Estoy usando HANA .Net

HanaConnection oData = new HanaConnection(CadenaCon);
oData.Open();


    
                HanaCommand cmd = new HanaCommand("", oData);
                cmd.CommandText = "JC1_NATIVO_Select";
                cmd.CommandType = CommandType.StoredProcedure;

                HanaParameter param = new HanaParameter();
                param = cmd.CreateParameter();
                param.HanaDbType = HanaDbType.Integer;
                param.Direction = ParameterDirection.Input;
                param.Value = AntiguedadDias;
                cmd.Parameters.Add(param);
                cmd.ExecuteReader();

Me arroja: invalid name of function or procedure: JC1_NATIVO_SELECT

Saludos

2

jajajajajaja disculpen mis ratos…me vuelvo a contestar yo mismo…

HanaConnection oData = new HanaConnection(CadenaCon);
oData.Open();


    
                HanaCommand cmd = new HanaCommand("", oData);
                cmd.CommandText = @"""JC1_NATIVO_Select""";
                cmd.CommandType = CommandType.StoredProcedure;

                HanaParameter param = new HanaParameter();
                param = cmd.CreateParameter();
                param.HanaDbType = HanaDbType.Integer;
                param.Direction = ParameterDirection.Input;
                param.Value = AntiguedadDias;
                cmd.Parameters.Add(param);
                cmd.ExecuteReader();
1 me gusta