My brief search came up with execute dbms_lock.sleep(60);
for a 60 second sleep...although I have no way to test it :) -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe Martin D'Souza Sent: Wednesday, May 30, 2012 2:39 PM To: [email protected] Subject: Re: PAUSE or SLEEP a filters in between actions... We are on Oracle.. I was in fact searching for an Oracle equivalent.. Great minds :-) -----Original Message----- From: Longwing, LJ CTR MDA/IC Sent: Wednesday, May 30, 2012 4:31 PM Newsgroups: public.remedy.arsystem.general To: [email protected] Subject: Re: PAUSE or SLEEP a filters in between actions... Joe, If using SQL Server you could issue a Direct SQL of waitfor delay "00:00:01" this would call the DB and would return after SS seconds or HH:MM:SS if you wanted more than SS seconds....but I agree with everyone else...setting hard 'pauses' in place is not ideal, but sometimes necessary. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe Martin D'Souza Sent: Wednesday, May 30, 2012 2:06 PM To: [email protected] Subject: PAUSE or SLEEP a filters in between actions... ** We are updating an identity management system (OIM) using its SPML based WSDL. During the operations to suspend or resume a user the output status of this operation seems to always be ‘pending’ – which in reality is really an intermediate status before ‘success’ or ‘failure’. The lifespan of this intermediate status is just a brief fraction of a second before the update either succeeds or fails.. From the service consumption point of view, this intermediate status of ‘pending’ is not quite meaningful other than the the fact that the WSDL call was successful. Given a choice I would have rather had the option to wait for those few micro seconds, at what point the status of either ‘success’.. They have a operation in the same web service to query the status. Following the update WSDL with a query WSDL is what I thought would be my answer to getting the new status (although I do not like the option of have another WSDL call when there could have been one)... This query however returns the status of the the user pre update. Filters as we know have no ‘SLEEP’ type action, else I could have used that to pause the filter operations in between the update and query operation. Ideally it would have been perfect if there was an ability to introduce a pause between the two WSDL calls. Is there any ‘creative’ way of inserting a pause in a filter operation that maybe I do not know of? Joe _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
