On Wed, Jan 30, 2002 at 03:01:46PM -0800, Morrison Davis wrote:
> Hi ALL,
>
> I'm going through all my code and changing to placeholders
> now that I know this alleviates quoting problems. And I'm changing
> to bind_param definitions. The question I have, does it make
> a difference the fact that my columns are declared as VARCHAR2
> and my type are {TYPE => VARCHAR}. It seems to be working fine
> in the few places I tested it, just wonder if there are potential
> problems down stream? or is there a SQL_VARCHAR2 I should be using.
You *very rarely* need to specify a bind type at all.
Only for 'CHAR', LONG/LOB, and cusrors.
All else is ignored and just a waste of typing.
Tim.
