All Forums UDA
marcmc 112 posts Joined 12/05
12 Nov 2007
3813: The positional assignment list has too many values

This error does not seem to generate a SQLCODE, all my error handlers are standard and use SQLCODE.How can I handle this error.

marcmc 112 posts Joined 12/05
12 Nov 2007

my error handler DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN CALL sp_lo_insert_log(0, :v_i_run_job_id, :v_proc_name, 'ERROR', 'SQL_STATE: ' || CAST(:SQLSTATE AS VARCHAR(100)) || ' SQLCODE: ' || CAST(:SQLCODE AS VARCHAR(850)) ||' Progress Counter: ' || v_progress_counter ); SET v_return_code = 1; END;

You must sign in to leave a comment.