I'm obviously missing something here.

"SELECT NEXT VALUE FOR SSC_ROCKS;" is used twice in the question, so why aren't two numbers returned?