Naveen, I think option 2 would be your best...and you control the return of the Java Run-process by doing a Set-Field $PROCESS$ instead of a 'Run Process' action....the set-field process will wait for the external process to complete....which means you have to adjust your server process settings to be long enough for your process to complete within that timeout value.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of NNMN Sent: Saturday, July 17, 2010 12:18 PM To: [email protected] Subject: Document Save from Database Hi ARSers, Below is a situation which i am trying to sort out. 1. I have two systems, a Remedy system and a custom application which generates documents and stores it as blob. 2. I have access to read this blob from the Remedy system and save into an attachment. These are the methods which i have thought about, although i am not sure about its feasibility and . Method 1: Document generated will be read by calling a procedure using the Direct SQL from the blob data(although i don't know how to do this via PLQL if at all if its possible - if anyone knows please lemme know) and save into the filesystem. As soon as it is saved, i will call the PERFORM-ACTION-ADD-ATTACHMENT and save it into the required attachment field. Method 2: Document generated will be read by a java program which access the data and saves it as a file in a location which will be called by RUN PROCESS command line. As soon as it is saved, i will call the PERFORM-ACTION-ADD-ATTACHMENT and save it into the required attachment field. Now in this I am not sure how and when the return is going to happen when i call the RUN PROCESS to execute the java code. I would like to have your views, inputs and anything useful regarding this. Cheers, Naveen ----- With Warm Regards, Naveen -- View this message in context: http://old.nabble.com/Document-Save-from-Database-tp29192886p29192886.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

