Stored Procedure

Question

I have written one complex stored procedure with Cursor and temporary tables .and when i am going to execute that SP it will fist dispaly the message not result.so what shoud i do to get result first?

Hiten Pandya · Answer

Hi, Sukhanda Actually there are many possibilities of getting null values, did you get your values in your code page from view or html page? You must be check that first beacuse there may be some little mistake due to which you face this issue or post your code so that I can help you. Thanks for accepting answer glad that it helps you.

Hiten Pandya · Answer

Hi, can you please exaplain what exactly you want I mean the output of the cursor or what? What kind of message you get can you post screenshot so, I can determine? Because you put your cursor inside SP. So, If you don't have any SP related errors then it will give you "Command(s) completed successfully." message and if you want to see the output of cursor then copy your cursor, put it in new window and simply execute it. It will show you the output or errors of the cursor. Thanks.

Sukhada Vader · Answer

Hello, No any other issue i checked it.in error message i can clearly get that issue is releated to stored procedures message problem.

Sukhada Vader · Answer

Normally when we execute any Stored procedure then in result window there are 2 parts Results and Messages and it shows Result on results window..but in this case i am getting my answer correctly but messages window is showing first. and the problem is that , i used this procedure in c# code and i am getting null values. so there is any solution for this? Thanku.

Stored Procedure

Answers (4)