pro*c variable types

I'm looking at some pro*c code that has things like this:

  EXEC SQL begin declare section;

     char foo;
  EXEC SQL end declare section;

...

  EXEC SQL select nvl(bar,'null') into :foo from footable a where a.bar = :foo;

where the column type is varchar2(6). The purpose of these queries is simply to tell whether a particular row exists.

It looks like it could cause memory problems. A quick test didn't show any errors, but I'd like to know if this is something that pro*c handles explicitly or whether it is likely to cause problems eventually.

Thanks!
Leigh Received on Wed Jun 07 2006 - 12:58:01 CDT