Generation

generate functionSun, 13 Nov 2022

open an oracle connection and execute a stored procedure with descriptive logging and exception handling

def execute_stored_proc(proc_name, bind_vars, log_file_path, cnxn_str) : try: logging.basicConfig(filename=log_file_path, level=logging.INFO, format='%(asctime)s | %(message)s') cnxn = cx_Oracle.connect(cnxn_str) cursor = cnxn.cursor() logging.info(f'Executing {proc_name}.bindvars={bind_vars}') cursor.callproc(proc_name, (bind_vars,)) cursor.close() cnxn.close() logging.info(f'{proc_name} executed successfully') except cx_Oracle.DatabaseError as e: logging.error(f'{proc_name} error {e}: ') logging.exception(f'{proc_name} error {e}: ') return None execute_stored_proc

Questions about programming?Chat with your personal AI assistant