View Single Post

   
  #1 (permalink)  
Old 04-20-2008, 09:16 AM
malc_p@btinternet.com
 
Posts: n/a
Default 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

Reply With Quote