1 ALLOCATE  cursor-name CURSOR FOR RESULT SET rs-locator-variable