When I am scanning my job code snippet in sonarqube it stating :
Define a constant instead of duplicating the literal ‘&v_jobname’ 2 times.
Software qualities impacted:
Maintainability
Following the job code snippet :
SET TIMING ON
SET SERVEROUTPUT ON
@$LOG_HOME/scripts/lc_config_sql.include
DEFINE v_jobname = 'Insert-Job'
DEFINE v_dbase = '&APPLICATION_NAME'
@$LOG_HOME/scripts/lc_spool_preparer.sql
SPOOL &log_string
PROMPT ===================================================================
PROMPT 10. Log check start
PROMPT ===================================================================
WHENEVER SQLERROR CONTINUE
EXECUTE &log_user..log_check.log_check_start('&v_jobname', '&v_dbase');
WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
PROMPT ==============================================================
PROMPT 30. INSERT INTO business_unit_t
PROMPT ==============================================================
// Code for inserting data in business_unit_t table
PROMPT ===============================================================
PROMPT 160. Running the LogCheck stop procedure
PROMPT ===============================================================
WHENEVER SQLERROR CONTINUE
EXECUTE &log_user..log_check.log_check_stop('&v_jobname', '&v_dbase');
PROMPT ==============================================================
PROMPT 170. Exiting &v_jobname (&v_dbase)
PROMPT ==============================================================
EXIT SUCCESS
Please guide how to fix this issue .