Help: system call inside stored procedure 
Author Message
 Help: system call inside stored procedure

Hi,

I'm having problems make the SYSTEM call work inside a stored
procedure.

For example,

create procedure echo1(msg char(80))
system "/usr/bin/echo msg";
return;
end procedure

When I do a execute procedure echo1("hello world"),
I got back this error message:

668: System command cannot be executed
  1: Not owner

Anybody has any idea what is happening here?

I'm using Informix 5 on a Sparc 10 with SunOS 4.1.3.

Regards and thanks in advance,

Chee Meng

--
---------------------------------------------------------------------

Information Technology Institute, Singapore

Quote:
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<



Sun, 21 Apr 1996 11:33:40 GMT
 Help: system call inside stored procedure

Low Chee Meng asked:
|> >I'm having problems make the SYSTEM call work inside a stored procedure.
|> >For example,
|> >
|> >create procedure echo1(msg char(80))
|> >system "/usr/bin/echo msg";
|> >return;
|> >end procedure
|> >
|> >When I do a execute procedure echo1("hello world"),
|> >I got back this error message:
|> >
|> >668: System command cannot be executed
|> >  1: Not owner
|> >
|> >Anybody has any idea what is happening here?

Quote:
Jonathan Leffler writes:

|> I just tried your procedure using OnLine 5.01.UC1 on SunOS 4.1.3 and had no
|> trouble with any error messages.  Obvious things to check: you have execute
|> permission on /usr/bin/echo (I thought so), and your shell can also be
|> handled run by a sgid informix program?

Also check the permissions on $INFORMIXDIR/bin/sgidsh, which should be:
-rwsr-sr-x  1 root     informix   172032 Jun 22  1992 bin/sgidsh

Dave
Disclaimer: These opinions are not those of Informix Software, Inc.
**************************************************************************
"I look back with some satisfaction on what an idiot I was when I was 25,
 but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney



Sun, 28 Apr 1996 02:41:14 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. calling a stored procedure inside a stored procedure

2. Calling Stored Procedure that calls Stored Procedure in ASP

3. Calling Stored Procedure Inside a Cursor

4. Call a dynamic stored procedure inside a trigger

5. HELP: Stored procedure calling stored procedure

6. calling a stored procedure inside another sp

7. calling stored procedures from inside select

8. Calling a stored procedure inside a cursor

9. ODBC call inside stored procedure to other rdbms

10. Call an asp page from inside a stored procedure

11. Calling another storedprocedure from inside a stored procedure??

12. Calling all stored procedure inside an Oracle package ?


 
Powered by phpBB® Forum Software