Dear All,

My users are getting the error -668 System command cannot be executed.
when they try to insert data into a table through Tibco Adaptors.
I have a trigger which in turn fires a procedure whenever a data is inserted into a table. Below is the contents of my stored procedure -

CREATE PROCEDURE "rrunner".exceptionproc1(
v_serviceRequestNr LIKE csodetail_excp_tbl.serviceRequestNr,
v_activityNr LIKE csodetail_excp_tbl.activityNr
)
DEFINE v_value CHAR(255);
DEFINE str CHAR(255);
set debug file to "/home/rrunner/exception.txt";
trace on;
LET str = "/home/rrunner/PI/bin/mail_exceptions.ksh";
IF (LENGTH(v_serviceRequestNr) > 0) THEN
LET str = trim(str) || " " || trim(v_serviceRequestNr);
END IF;
IF (LENGTH(v_activityNr) > 0) THEN
LET str = trim(str) || " " || trim(v_activityNr);
END IF;
SYSTEM str;

trace off;
END PROCEDURE;

It fails at the system command, which trieds to generate a mail. However when i try to insert data using winsql / dbaccess i can insert it successfully. It only fails using Tibco Adaptors. I have checked all the permissions. Am i missing something else. please advise.

Thanks in advance.

Regards,

Lloyd