adspace


What action do you have to perform before retrieving data
from the next result set of a stored procedure ?

Answer Posted / Ashish Kumar Johri

Before retrieving data from the next result set of a stored procedure, you typically need to call a fetch or similar method that moves to the next record in the result set. This operation is usually repeated until there are no more records left in the result set.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is dbms? : Sql dba

1061


what is sql server agent? : Sql dba

1182


How do I remove duplicates in two columns?

1187


Does group by remove duplicates?

1112


Do we need to rebuild index after truncate?

1138


Is primary key always clustered index?

1095


What is the best sql course?

1050


Is primary key clustered index?

1019


what is collation? : Sql dba

1229


what are the advantages of sql ? : Sql dba

1142


Is inner join faster than left join?

1277


Can delete statement be rollbacked?

1054


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2091


how to escape special characters in sql statements? : Sql dba

1114


what is bcp? When does it used? : Sql dba

1056