Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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.