RE: Calling SYSTEM from Stored Procedure...

in your scrip add env > /tmp/eric and then x-check this against the working enviroment Paul Watson # WF Software Ltd # If in doubt Tel: +44 1436 674729 # make it up Fax: +44 1436 678693 # www.wfsoftware.com # > -----Original Message----- > From: Stephens, Alan [mailto:alans@credo.ie] > Sent: Friday, August 04, 2000 9:41 AM > To: informix-list@iiug.org > Subject: Calling SYSTEM from Stored Procedure... > > > Solaris 2.6 > Dynamic Server 7.31 > > I have a shellscript bleah.sh as follows > > #!/bin/sh > . /bleah/setup_ld_library_path_variables > /bleah/runbinary > > When I run this at the command line it runs fine - > the script gets run which sets up the LD_LIBRARY_PATH > needed for the binarys run time libraries. > > I want to run bleah.sh from a stored procedure. > I make my SYSTEM call as normal - it finds and runs > bleah.sh ok but the binary fails to run because it cannot > find the run time libraries (ie. LD_LIBRARY_PATH must not > be set?) > > 1) Why is this ? Why is different to running from the command line > 2) How do you get around the problem... > > A. > > > The contents of this e-mail are confidential to the ordinary user(s) of the mail address(es) to which it was sent and may be legally privileged. If you are not the intended recipient, any disclosure, copying, distribution or use of it, or any part of it, in any form whatsoever, and any actions taken or omitted to be taken in reliance on it, is prohibited and may be unlawful.