Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Dynamic SQL - proC - Method 4
Sylvain Benoist wrote:
> When we want to get some data from the database by using this application,
> everything works fine except with the "string" fields. Indeed, if the type
> of one field is varchar(10) and this field contains 4 characters, the
> Dynamic SQL method 4 will return a string containing 10 characters with the
> 4 corresponding characters + 6 spaces.
You need to set s->T[i] to 5 ("C"-string) of the varchar2 columns. You probably used 1 ("char") or 9 ("varchar").
Erwin Received on Tue Jul 24 2001 - 02:52:18 CDT