RE: DBI bind_param_inout question

 

> Date: Tue, 9 Mar 2010 08:42:28 +0000
> From: [email protected]
> To: [email protected]
> CC: [email protected]; [email protected]
> Subject: Re: DBI bind_param_inout question
> 
> John Scoles wrote:
> > Silly me you do need it so rare that I use it day to day.
> > 
> > In my case I usualy use it like this
> > 
> > $c->bind_param_inout(":p_new_id",\$p_new_id,SQL_DECIMAL);
> > 
> 

ouch bug in my code 'seems SQL_DECIMAL is 3 so I guess I am in fact doing this

 

$c->bind_param_inout(":p_new_id",\$p_new_id,3);

 

most likey getting away with as in Oracle is it 3 bytes which should hold most of the numbersin the code I wuse it for.

 

my guess qould be to use 38 or even more.

 

 

In DBD::Oracle the value is always in bytes never characters.

 


> I think you mean
> 
> $c->bind_param_inout(":p_new_id",\$p_new_id,$length,SQL_DECIMAL);
> 
> as the $length is compulsory but the bind type (SQL_DECIMAL) is optional.
> 
> > 
> > or more properly
> > 
> > $c->bind_param_inout(":p_new_id",\$p_new_id,ORA_NUMBER);
> > 
> $c->bind_param_inout(":p_new_id",\$p_new_id,$length, ORA_NUMBER)
> 
> > 
> > basiclly not to get into the low down stuff in OCI we have to tell OCIBindByName how many bytes to expect for this bind.
> > 
> 
> As it does in DBD::ODBC. If for instances, you said $length was 10 then
> the output bound parameter was 20 bytes in length you'd get a data right
> truncation error in DBD::ODBC.
> 
> There is however one possible area of ambiguity with respect to bytes or
> characters (within a DBD). DBD::ODBC counts the $length as characters
> not bytes as how it is eventually encoded in Perl should not matter. So
> if you specify $length=10 and the output parameter is a wide (MS's term
> in ODBC for a unicode character that occupies 2 bytes) character type
> DBD::ODBC allocates twice as much plus 2 (for the terminating nul chr)
> bytes then encodes it in UTF-8 for Perl - so you'd get at most 10 chrs.
> In this case if the output parameter was 11 chrs in length you'd get a
> data right truncation error again.
> 
> I'm not sure what DBD::Oracle does wrt to chrs or bytes.
> 
> > from the OCI doc
> > 
> > 'The size in bytes of the data value pointed to by dvoid pointer valuepThe size in bytes of the data value pointed to by dvoid pointer valuep" 
> > 
> > Hope this helps.
> > 
> > cheers
> 
> Martin
> -- 
> Martin J. Evans
> Easysoft Limited
> http://www.easysoft.com
> 
> >> CC: [email protected]
> >> From: [email protected]
> >> To: [email protected]
> >> Subject: Re: DBI bind_param_inout question
> >> Date: Mon, 8 Mar 2010 17:11:34 -0700
> >>
> >>
> >> On Mar 8, 2010, at 4:52 PM, John Scoles wrote:
> >>
> >>> depends on the DBD::Driver implimentation.
> >>>
> >>>
> >>>
> >>> In DBD::Oracle the maxlenth usually means nothing. Not sure about 
> >>> other drivers.
> >>>
> >>>
> >>>
> >>> which one are you using?
> >>>
> >> I'm using oracle. I get an error if I don't include it, but from what 
> >> you're saying it's just a dummy value, it just has to have a value?
> >>
> >> -- 
> >> Bruce Johnson
> >> University of Arizona
> >> College of Pharmacy
> >> Information Technology Group
> >>
> >> Institutions do not have opinions, merely customs
> >>
> >>
> > 
> > _________________________________________________________________
> > Take your contacts everywhere
> > http://go.microsoft.com/?linkid=9712959
> 
> 

 		 	   		  
_________________________________________________________________
Live connected with Messenger on your phone
http://go.microsoft.com/?linkid=9712958