<commit_before>create or replace package body test_ut_executable is

  g_dbms_output_text varchar2(30) := 'Some output from procedure';

  procedure exec_schema_package_proc is
    l_executable ut3.ut_executable;
    l_test       ut3.ut_test;
    l_result     boolean;
  begin
    --Arrange
    l_test := ut3.ut_test(a_object_name => 'test_ut_executable',a_name => 'test_ut_executable');
    l_executable := ut3.ut_executable_test( null, 'test_ut_executable', 'passing_proc', ut3.ut_utils.gc_test_execute );
    --Act
    l_result := l_executable.do_execute(l_test);
    --Assert
    ut.expect(l_result).to_be_true;
    ut.expect(l_executable.serveroutput).to_be_null;
    ut.expect(l_executable.get_error_stack_trace()).to_be_null;
  end;

  procedure exec_package_proc_output is
    l_executable ut3.ut_executable;
    l_test       ut3.ut_test;
    l_result     boolean;
  begin
    --Arrange
    l_test := ut3.ut_test(a_object_name => 'test_ut_executable',a_name => 'test_ut_executable');
    l_executable := ut3.ut_executable_test( user, 'test_ut_executable', 'output_proc', ut3.ut_utils.gc_test_execute );
    --Act
    l_result := l_executable.do_execute(l_test);
    --Assert
    ut.expect(l_result).to_be_true;
    ut.expect(l_executable.serveroutput).to_equal(to_clob(g_dbms_output_text));
    ut.expect(l_executable.get_error_stack_trace()).to_be_null;
  end;

  procedure exec_failing_proc is
    l_executable ut3.ut_executable;
    l_test       ut3.ut_test;
    l_result     boolean;
  begin
    --Arrange
    l_test := ut3.ut_test(a_object_name => 'test_ut_executable',a_name => 'test_ut_executable');
    l_executable := ut3.ut_executable_test( user, 'test_ut_executable', 'throwing_proc', ut3.ut_utils.gc_test_execute );
    --Act
    l_result := l_executable.do_execute(l_test);
    --Assert<commit_msg>Fixed newline in `ut_executable` for dbms_output.<commit_after>create or replace package body test_ut_executable is

  g_dbms_output_text varchar2(30) := 'Some output from procedure';

  procedure exec_schema_package_proc is
    l_executable ut3.ut_executable;
    l_test       ut3.ut_test;
    l_result     boolean;
  begin
    --Arrange
    l_test := ut3.ut_test(a_object_name => 'test_ut_executable',a_name => 'test_ut_executable');
    l_executable := ut3.ut_executable_test( null, 'test_ut_executable', 'passing_proc', ut3.ut_utils.gc_test_execute );
    --Act
    l_result := l_executable.do_execute(l_test);
    --Assert
    ut.expect(l_result).to_be_true;
    ut.expect(l_executable.serveroutput).to_be_null;
    ut.expect(l_executable.get_error_stack_trace()).to_be_null;
  end;

  procedure exec_package_proc_output is
    l_executable ut3.ut_executable;
    l_test       ut3.ut_test;
    l_result     boolean;
  begin
    --Arrange
    l_test := ut3.ut_test(a_object_name => 'test_ut_executable',a_name => 'test_ut_executable');
    l_executable := ut3.ut_executable_test( user, 'test_ut_executable', 'output_proc', ut3.ut_utils.gc_test_execute );
    --Act
    l_result := l_executable.do_execute(l_test);
    --Assert
    ut.expect(l_result).to_be_true;
    ut.expect(l_executable.serveroutput).to_equal(to_clob(g_dbms_output_text||chr(10)));
    ut.expect(l_executable.get_error_stack_trace()).to_be_null;
  end;

  procedure exec_failing_proc is
    l_executable ut3.ut_executable;
    l_test       ut3.ut_test;
    l_result     boolean;
  begin
    --Arrange
    l_test := ut3.ut_test(a_object_name => 'test_ut_executable',a_name => 'test_ut_executable');
    l_executable := ut3.ut_executable_test( user, 'test_ut_executable', 'throwing_proc', ut3.ut_utils.gc_test_execute );
    --Act
    l_result := l_executable.do_execute(l_test);
    --Assert
{'fraction_non_alphanumeric': 0.10779256041270703, 'fraction_numerical': 0.010317675807765408, 'mean_word_length': 4.166900420757363, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 15, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '7199488', 'n_tokens_mistral': 1392, 'n_tokens_neox': 1378, 'n_words': 196}