We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
BEGIN UPDATE GPQ_MQ_DATA SET WNDW_SVC_ID = i_server_id WHERE MQ_ID IN (SELECT MQ_ID FROM (SELECT MQ_id, ROWNUM rn FROM (SELECT MQ_ID FROM GPQ_MQ_DATA WHERE STATUS = '1' AND NVL (WNDW_SVC_ID, 0) = 0 ORDER BY MQ_ID ) ) x WHERE rn <= i_rec_count ); OPEN o_recordset FOR SELECT MQD.MQ_ID, MQD.MQ_TYPE, MQD.MQ_DATA_COL.GETSTRINGVAL() XMLDATA, MQD.S_ROW_UPD FROM GPQDBO.GPQ_MQ_DATA MQD WHERE WNDW_SVC_ID = i_server_id AND STATUS = '1'; -- 1 scheduled to process. EXCEPTION WHEN NO_DATA_FOUND THEN NULL; WHEN OTHERS THEN raise_application_error (-20101, SQLERRM, TRUE); END; /
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.