error_number(); data services designer

[former_member283957]

Dear All,

I am using data services designer for ETL jobs.

When I try to insert a register that already exists I get "Error: ORA-00001: unique constraint (string.string) violated"

but the value of $BITA_VGB_ERR = error_number(); is 0  and 0 means no errors.

Which is the number return by error_number() captured by a CATCH OBJECT after an ORA_00001 ?

I GET 0 but 0 is no errors and I got ORA_00001

Thanks in advance-

Best Regards

Antonio

$BITA_VGB_JOB_NAME = job_name();

$BITA_VGB_ERR = error_number();

$BITA_VGB_ERR_CTX = error_context();

$BITA_VGB_ERR_MSG = error_message();

$BITA_VGB_ERR_TIME = error_timestamp();

$BITA_VGB_ERR_DATE =  ((year(error_timestamp())* 10000) + (month(error_timestamp())*100))+ day_in_month(error_timestamp());

$BITA_VGB_FILE_JOB_LOG = 'log_'||$BITA_VGB_JOB_NAME||$BITA_VGB_ERR_DATE || '.txt';

sql('BITA_DS_DEST','INSERT INTO BITA_DW_DM_CONTROL_ERRORES (NUM_ERR, JOB_NAME_ERR, CTX_ERR, MSG_ERR, FC_REGISTRO_BBDD, DATE_ERR) VALUES('||$BITA_VGB_ERR||',{$BITA_VGB_JOB_NAME}, {$BITA_VGB_ERR_CTX},{$BITA_VGB_ERR_MSG}, sysdate,'||$BITA_VGB_ERR_DATE||')');

[arijit_das]

I think this post is related to and has to be moved to that space.