Hi @kirankumar.mahanthi1 ,
It is not throwing any error and it is executing fine. But, the output datatable is empty.
And, in that SP, ‘ACCOUNT_NUMBER’ is the input and ‘ORDER_ID’ is the output arguments respectively. When, we execute the SP, it should return a value to ‘ORDER_ID’.
By seeing the screenshot I could find that your storing your query in a text file and reading and input that text directly in execute query will not work I guessm
CREATE PROCEDURE sp
Create procedure with your statement in your db and call that name in the execute query SQL option as “sp”. I think we cannot execute the query directly after selecting drop down as stored procedure. Please try and let us know. Thanks.
Are you able to create procedure in your db (execute your statement by adding create procedure statement) with the name sp with your statement mentioned above.
Once we successfully create the stored procedure in your db.
Please use that stored procedure name in the query option in our case “sp” and try execute. Please share the output of your db if possible. Thanks.
Please don’t run the entire query in the execute query as statement. Since we selected dropdown as stored procedure we have to give the stored procedure name only in the query section not entire query.
Stored procedure is already exist in the DB. It is parameterized. When I try to call it by name, by passing the parameters, it is throwing error.
We pass parameters using ‘@’. But it is throwing error, something like, unexpected symbol.