Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
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; /
|Learning Processes involved in building a asp.net mvc (C#) application that uses an Oracle database||8||106|
|SQL2016 to ORACLE11G linked-server||6||28|