CODEWITHSUNDEEP
mysqlstored-procedures
Shuby2011modern
Shuby2011modern

Reputation: 11

Stored Procedure returning multiple values?

I have created a stored procedure that is returning multiple integer type values. What datatype should I give to out parameter to store all returned values in the out param. Currently I have given int datatype so it is giveing error "multiple rows has been returned". Can anyone please help me out.

Upvotes: 1

Views: 363

Answers (1)

chandrakanth
chandrakanth

Reputation: 1

u can not store all return values into a single output param. You have to create 1 output param for each return value and assign them properly. Best way is to use select statements/temp tables to read whole data instead of output params

Upvotes: 0

Related Questions