Re: Stored Procedure - cannot include a system call
Thanks to all those who answered my orignal posting re using system calls in
stored procedures in SE 7.1 Since posting I have been in contact with Informix
tech support and have found out that it is a known bug. According to tech
support, system calls do not work in stored procedures under SE 7.1.
Details of the bug are given below.
What I need to do is find some sort of work around. I need to trigger a
system call in Informix using ISQL or a stored procedure. I can't think of
any way of doing this, other than using a system call in a stored procedure,
which cannot of course work. Any suggestions would be welcome. I cannot
upgrade my version of Informix as the version of SE where the bug is fixed is
incompatible with my OS. And I cannot change my OS at this time.
Details of bug from Informix follow:
---------
bugp 59226
Bug: 59226 STORED PROCEDURE USING SYSTEM CALL RETURNS ERRORS 668/1 WHEN
USING STANDARD ENGINE
Date: 1996-09-19 Category: BACKEND
Type: SW
this bug was not reproduced in 7.20 version of Standard Engine.
-------------------------------------
Re: Stored Procedure - cannot include a system call
In article <memo.19981020192608.34385Y@wfsoftware.compulink.co.uk>,
paulw@wfsoftware.co.uk wrote:
> In article <70g4ke$vh9$1@nnrp1.dejanews.com>, kcj@mechoshade.com () wrote:
>
> > When I include a system call in a stored procedure I get an error when I
> > attempt to execute it.
> >
> > 668: System command cannot be executed.
> > 1: Not owner> >
> > I am the owner of the database. I get the same message when I log on as
> > /usr/informix
> >
> > The stored procedure is as follows:
> > -----------------------------------------
> > CREATE dba PROCEDURE call_wo (vwo INT)
> > system "echo 'test this'";> > END PROCEDURE
> > -----------------------------------------
> >
> > Can anyone give me any ideas as to what could be wrong here.
> >
> > I am running INFORMIX se 7.10 under SCO 3.2.4.2
> >
> > Kate Juliff
>
> The obvious question is where is this to be echo'd to?
>
> This is a Unix permissions problem, if
>
> system "touch /tmp/filename";
>
> works then you are trying to create/modify a file in the working directory
> you are not allowed to. If it fails then are sure everything has been
> installed correctly?
>
> Paul Watson # I don't suffer from
> WF Software Ltd. # stress, I'm just
> Tel. (+44) 1436 674729 # a carrier
> Fax. (+44) 1436 678693 #
> www.wfsoftware.co.uk
>
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own