MySqlCommand cmd1 = connMySQL.CreateCommand() Ĭmd1.CommandType = CommandType.StoredProcedure Ĭ(new MySqlDbType. For someone from dotnet framework and C background, dotnet core is. Var json1 = .Serialize(jsonRequest) ĬonnMySQL.ConnectionString = m圜onnectionString endpoint: GraphQL base URL timeout: timeout for requests in. String stored_procedure = “ReportData” string m圜onnectionString = "Server=s Port=3306 Uid= Pwd= Database= checkparameters=false" Ĭase_name = "tes", view = "gg", acct_account_code = "888-0000", busn_business_code = "888", func_function_code = "000", enty_entity_code = "000", proj_project_code = "000", time_month = "JAN", Net ? I tried below code but it doesnt work.ĬREATE OR REPLACE PROCEDURE ReportData(jsonArray ARRAY(json)) AS The idea is to put some commonly or repeatedly done task together and make a function so that instead of writing the same code again and again for different inputs, we can call the function. How do we can call stored procedure with json array as input to store procedure from. A function is a set of statements that take inputs, do some specific computation and produces output.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |