We have made some progress on this - it appears the issus is tied to a difference between Oracle 9i and 10g and how the "Alter Session" command works in a stored procedure. William Rentfrow Principal Consultant, StrataCom Inc. [email protected] Corporate Website, www.stratacominc.com <http://www.stratacominc.com/> Blog, www.williamrentfrow.com <http://www.williamrentfrow.com/> 715-410-8156 C
________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe DeSouza Sent: Tuesday, August 18, 2009 7:31 PM To: [email protected] Subject: Re: ARERR 552 - Database link is not open ** William, How are you running the Stored Proceedure from Remedy? I mean the exact syntax of how you are trying to execute it.. Joe ________________________________ From: William Rentfrow <[email protected]> _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

