Re: Stored Procedure Question

Succinctly, No. The problem is that passwd expects to read from the terminal (/dev/tty), not standard input, but the SP is being executed (in 7.12) in a server process which has no controlling terminal (and standard input is unlikely to be the terminal either). So passwd doesn't stand a chance. If you were using 5.0x, there is an outside chance that you could do it, but I'd not like to count on it. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >Date: Tue, 18 Jun 1996 14:15:23 -0400 >From: Sanjay Kumar <SOHO!dpsanjay@whitestone.raileurope.com> >X-Informix-List-Id: <list.10346> > >Is it possible for change your password by invoking a Stored Procedure ? >I tried it by calling: SYSTEM passwd > >but I get an error # 668 and ISAM Error 1. >Is there any way to get around this problem ? I use 7.12 on Dec Alpha 3.2.