well, after i put the : before my into variable (:hl7_msg_in) it ran successfully in normal mode.
according to oracle, here is the sql stmt that is currently executing.
declare
-- Probe 2.1
backtrace sys.dbms_debug.backtrace_table;
program_info sys.dbms_debug.program_info;
i integer...