Great and wise Perl monks,

I'm a Perl novice still endeavoring through my journey to your great and vaunted status.

How the heck do I set a 'max_len' parameter when using DBI and 'bind_param'?

I'm encountering an issue where one of the parameters that I'm attempting to bind can be over thousands of characters long and exceeding the default maxlen and flowing into the next parameter. Below is what I'm seeing in my DBI 'trace.txt': 
bd_bind_ph(1): bind :p52 <== ''James K3Home AddressCity, State 28301Ja
+mes.K3@address.comPhone: (111)111-1111OBJECTIVEPursuing a position th
+at would allow me to utilize my computer skills while allowing me to 
+contribute to a dynamic business environment.SKILLSLinux administrati
+on (CentOS/Ubuntu)Writing and maintaining Bash scripts Writing and ma
+intaining Perl scriptsWriting and maintaining Standard Operating Proc
+eduresVMWare ESXiEMC Unisphere Management (VNXe) Server RackingProfic
+ient in Windows and Linux systems administrationPhone/Network cabling
+EXPERIENCE As a Systems Administrator with the CompanyImWith I am res
+ponsible for maintining a wide array of infrastructure, ensuring that
+ system security and maintenance is maintained without negatively imp
+acting production workflows.  In my current role my team and I manage
+ 270 servers, working with ESXi 5.5, Oracle Enterprise Linux (5.8 . 6
+.6), as well as Server 2000 . 2012r2.  While with CompanyImWith I hav
+e taken the lead on implementing monitorin...' (type 0 (DEFAULT (varc
+har)))
dbd_rebind_ph_char() (1): bind :p52 <== ''Jame...' (size 3746/3752/0, 
+ptype 5(LONG), otype 8 )
dbd_rebind_ph_char() (2): bind :p52 <== ''Jame...' (size 3746/3752, ot
+ype 8(LONG), indp 0, at_exec 1)
          bind :p52 as ftype 8 (LONG)
dbd_rebind_ph(): bind :p52 <== ''Jame...' (in, not-utf8, csid 1->0->1,
+ ftype 8 (LONG), csform 0(0)->0(0), maxlen 3752, maxdata_size 0)
dbd_bind_ph(1): bind :p53 <== ' ensuring proper adherence to the dicta
+tes of the NISPOM while assisting the customer in maintaining mission
+ readiness and accomplishment. In my role as the AFSO I assiste

[download]
TIA!
James

In reply to How to set 'max_len' for DBI 'bind_param' by JamesK3

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.