Stored Procedure

Sukhada Vader

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?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Hiten Pandya8y ago
Accepted 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.
0
Sukhada Vader8y ago
Hello,
No any other issue i checked it.in error message i can clearly get that issue is releated to stored procedures message problem.
0
Sukhada Vader8y ago
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.
0
Hiten Pandya8y ago
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.
+3