PROCEDURE WRITE
\n( p_text\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 IN VARCHAR2
\n, p_file\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 IN VARCHAR2 DEFAULT ‘d_log.log’
\n, p_action\u00a0\u00a0\u00a0\u00a0 IN VARCHAR2 DEFAULT ‘A’
\n, p_log_table\u00a0 IN BOOLEAN\u00a0 DEFAULT FALSE
\n, p_log_status IN VARCHAR2 DEFAULT ‘SUCCESS’
\n) IS
\nv_log utl_file.file_type;
\nPRAGMA AUTONOMOUS_TRANSACTION;
\nBEGIN
\nv_log\u00a0 := utl_file.fopen( ‘LOG’
\n, p_file
\n, p_action
\n);
\nutl_file.put_line( v_log
\n, TO_CHAR(SYSDATE,’YYYY-MM-DD HH24:MI:SS’) || ‘ ‘ || p_text
\n);
\nutl_file.fclose( v_log );
\nIF p_log_table
\nTHEN
\nINSERT INTO dwfacts.batch_log
\n( log_date
\n, log_text
\n, log_status
\n)
\nVALUES ( SYSDATE
\n, p_text
\n, p_log_status
\n);
\nCOMMIT;
\nEND IF;
\nEND WRITE<\/p>\n","protected":false},"excerpt":{"rendered":"
PROCEDURE WRITE ( p_text\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 IN VARCHAR2 , p_file\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 IN VARCHAR2 DEFAULT ‘d_log.log’ , p_action\u00a0\u00a0\u00a0\u00a0 IN VARCHAR2 DEFAULT ‘A’ , p_log_table\u00a0 IN BOOLEAN\u00a0 DEFAULT FALSE , p_log_status IN VARCHAR2 DEFAULT ‘SUCCESS’ ) IS v_log utl_file.file_type; PRAGMA AUTONOMOUS_TRANSACTION; BEGIN v_log\u00a0 := utl_file.fopen( ‘LOG’ , p_file , p_action ); utl_file.put_line( v_log , TO_CHAR(SYSDATE,’YYYY-MM-DD HH24:MI:SS’) || ‘ ‘ || […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-20","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.rdlpconsultants.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/posts\/20","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rdlpconsultants.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rdlpconsultants.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rdlpconsultants.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rdlpconsultants.co.uk\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=20"}],"version-history":[{"count":2,"href":"https:\/\/www.rdlpconsultants.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/posts\/20\/revisions"}],"predecessor-version":[{"id":65,"href":"https:\/\/www.rdlpconsultants.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/posts\/20\/revisions\/65"}],"wp:attachment":[{"href":"https:\/\/www.rdlpconsultants.co.uk\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=20"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rdlpconsultants.co.uk\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=20"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rdlpconsultants.co.uk\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=20"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}