SPL behaving oddly HP-UX 11i, IDS 9.30HC5
Afternoon chaps
We have an SPL which is failing to run here - it's a fairly simple one
used to call a shell script when executed, code as follows:
CREATE FUNCTION "dba".request_proj(env CHAR(5),user CHAR(12), pref INT,
cref INT
)
RETURNING INT;
DEFINE path CHAR(50);
DEFINE error_num INT;
DEFINE error_val INT;
ON EXCEPTION
SET error_num,error_val
END EXCEPTION WITH RESUME
LET error_val = 0;
LET path =
'/opt/'||TRIM(env)||'/progs/general/interfaces/proj_request/'
;
SYSTEM TRIM(path)||'proj_request.sh ' ||TRIM(env)||' '||user||'
'||
pref||' '||cref;
RETURN error_val;
END FUNCTION;
..... and it's failing with a return code of -2, and the following is
put into the IDS message log:
11:26:09 execve() of " -c
/opt/ROBIN/progs/general/interfaces/proj_request/proj_request.sh ROBIN
inetuser 290 1002678" failed errno=2
This is palpably rubbish - the -2 error is "No such file or directory"
but the file is there - I've even set the access perms on it and it's
path to 777.
Does anyone know what execve() is doing?
Anyone seen this before?
Puzzled of West Malling |