search

connell-class / revassess

this is a trial repo for making a template for the revature assessment
2 stars 11 forks source link

Tier 3 Problem 4 may be too difficult for time constraint #52

Open ghost opened 4 years ago

ghost commented 4 years ago

Describe the bug Problem 4 (below) for tier 3 seems to be to difficult to complete within the time constraint for the assessment, due to a cursor being returned by the function. Please place a comment on this issue to suggest a replacement question that would be a little bit easier to complete within the time constraint.

"Implement a stored procedure that takes a user's id as an IN parameter and a cursor as a OUT parameter. This procedure will insert a result set into the provided cursor; the result set must contain the study sets belonging to the user with the provided id."

To Reproduce N/A

Expected behavior N/A

Screenshots N/A

Desktop (please complete the following information):

Additional context Please place a comment on this issue to suggest a replacement question that would be a little bit easier to complete within the time constraint.

ghost commented 4 years ago

One thought would be to have the function insert data passed to it through parameters into the database. Another thought would be to have the function return a single value instead of a result set.