Attention pour remonter les erreurs SQL dans VTOM, il faut ajouter la ligne :<\/p>\n
WHENEVER SQLERROR EXIT SQL.SQLCODE<\/strong><\/p>\n apr\u00e8s la connexion sqlplus, stocker le resultat dans une variable err_sql=$?<\/strong> puis sortir avec la valeur de la variable.<\/p>\n exemple : <\/span><\/p>\n sqlplus ${1}\/${2} < $0.txt err_sql=$?<\/strong><\/span><\/p>\n …..<\/span><\/p>\n exit $err_sql<\/strong><\/span><\/p>\n \u00a0<\/span><\/p>\n sqlplus $1\/$2 <WHENEVER SQLERROR EXIT SQL.SQLCODE<\/strong><\/span> si l’instruction sqlplus est suivie d’une autre instruction, envoi de mail par exemple, il faut m\u00e9moriser la valeur de l’erreur sql et la transmettre en fin de script.<\/p>\n sqlplus $1\/$2 <WHENEVER SQLERROR EXIT SQL.SQLCODE<\/strong><\/span> err_sql=$?<\/strong><\/span><\/p>\n ${ABM_BIN}\/tmail -c ${ABM_BIN}\/tmail.ini -cc $4 -sub « Traitement $TOM_JOB Termin\u00e9 » -msg » exit $err_sql<\/strong><\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":" Attention pour remonter les erreurs SQL dans VTOM, il faut ajouter la ligne : WHENEVER SQLERROR EXIT SQL.SQLCODE apr\u00e8s la connexion sqlplus, stocker le resultat dans une variable err_sql=$? puis sortir avec la valeur de la variable. exemple : sqlplus ${1}\/${2} < $0.txt WHENEVER SQLERROR EXIT SQL.SQLCODE EXEC csv.generate(‘DIR_EXPORT_CSV’, ‘${3}.csv’,’SELECT * FROM ${4}’); exit EOSQL … Continuer la lecture de « Remont\u00e9 des Erreurs SQL dans VTOM »<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[43],"tags":[],"_links":{"self":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/249"}],"collection":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/comments?post=249"}],"version-history":[{"count":0,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/249\/revisions"}],"wp:attachment":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/media?parent=249"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/categories?post=249"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/tags?post=249"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nWHENEVER SQLERROR EXIT SQL.SQLCODE<\/strong>
\n<\/span>EXEC csv.generate(‘DIR_EXPORT_CSV’, ‘${3}.csv’,’SELECT * FROM ${4}’);
\n<\/span>exit<\/span>
\n<\/span>EOSQL<\/span><\/p>\n
\nexec Pack_Batch_Quotidien.p_quotidien($3);
\nexit
\nEOSQL<\/em><\/span><\/p>\n
\nexec Pack_Batch_Quotidien.p_quotidien($3);
\nexit
\nEOSQL<\/span><\/em><\/p>\n
\nBonjour,
\nLe traitement est termin\u00e9, v\u00e9rifier les fichiers logs joints.*
\nBonne journ\u00e9e. »<\/span><\/em><\/p>\n