Bang (!) in utl_mail message
From: steve montgomerie <stmontgo_at_gmail.com>
Date: Tue, 12 Aug 2008 14:09:52 -0400
Message-ID: <5d4504220808121109p392e3b33u8d76b6967aa247@mail.gmail.com>
ble does not exist
Date: Tue, 12 Aug 2008 14:09:52 -0400
Message-ID: <5d4504220808121109p392e3b33u8d76b6967aa247@mail.gmail.com>
Hello,
Is there a buffer limit or something for the message portion of utl_file?
I have a procedure that does some pre data load checks and then sends them
out through utl_mail.
something like data_load_check_1 || chr(13) || data_load_check_2 || chr(13)
etc etc etc
The chr(13) is for the carraige return.
If you look below after about 19 lines Oracle throws in a ! and carraige return. Have I hit a limit in message size?
<snip>
INFO Gen stats procedure exists and is VALID INFO A POST_LOAD_FROM_BLAH restore point has been created INFO PSDBOWNER ta!
ble does not exist
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 12 2008 - 13:09:52 CDT