On 8/16/07, Dunbar, Norman <norman.dunbar_at_environment-agency.gov.uk> wrote:
>
>
> The MXL=128(50) says max length is 128 current length is 50. Also, the
> AVL=50 confirms that the actual length of the bind data is indeed 50.
>
> So, you are passing a 50 character value over. If, as others have
> suggested, you were passing NULL then AVL would be zero. The number in
> parenthesis after the MXL is 'random' in that instance - cannot be
> trusted.
>
Nice catch!
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 16 2007 - 12:51:54 CDT
