On Wed, Feb 18, 2004 at 03:37:38PM +0000, Lauder, Andy wrote:
> Is the bind_param command working correctly in that you cannot change the
> ora_type value after it is initially set?
Yes.
> I am trying to explicitly set the ora_type value after it is initially set,
> as a workaround for a problem where ora_type set to VARCHAR2 (default)
> strips off trailing spaces. Whenever I want to insert a space into a "NOT
> NULL" field, I explicitly set the ora_type value to ORA_CHAR to prevent
> trailing spaces from being removed. However, if the bind parameter ora_type
> has already been set to ORA_VARCHAR2, I cannot change it and the insert
> fails.
You could try $dbh->{ora_ph_type} = 5; # STRING
Tim.
