Re: Stored Procedure - cannot include a system call
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