On Tue, Mar 11, 2003 at 09:28:50PM -0500, Matthew O. Persico wrote: > --- Original Message --- > From: "M. Addlework" <[EMAIL PROTECTED]> > To: Matthew O. Persico <[EMAIL PROTECTED]> > Cc: > Sent: Tue, 11 Mar 2003 15:59:27 -0800 (PST) > Subject: Re: Fwd: Cannot bind a single blank space to a non-null varchar? > > > > >>Why isn't the trailing whitespace stripped in the third insert? Is > >>this an SQLPLUS aberration? > > > >Sort of. ?The space trimming is happening in OCI, but sqlplus > >does not use OCI. ?Nor does PL/SQL. > > > >OCI is for third-parties. ?Internally, Oracle has a different API. > > Oh, so the high and exalted internal apps get a high powered API and we get stuck > with something else? > > Maybe that's unfair, but that's what it looks like to me.
The issue is what 'extern type code' is used for the placeholders. Oracle has several character types with different behaviours (such as allowing embedded nulls and/or stripping trailing spaces). Google for DBD::Oracle ora_ph_type Bunce for more info. Tim.
