Additional
dbCAP
AnyDAC
ThinDAC
NCOCI8
Topic: Pl/SQL tables of char(x) type
Pl/SQL tables of char(x) type
Posted: 2001/03/29 04:25
 
Hi,

How are tables of char(x) types fields retrieved?
I modified PL/SQL array demo to execute a
procedure that returns PL/SQL table of
char(2) type. First I was getting an error
that array binding types must match ... Then
I checked the types of the parameter and it
"saw" it as string. I then changed it to ftFixedString and otChar and length 2 and it
worked. Did I overlook something and that's
why char(2) was reported as String or do
chars need to be converted to varchars?

Thank you.
Sumar
RE: Pl/SQL tables of char(x) type
Posted: 2001/04/06 07:27
 
I figured it out. So that you know, just set the EnableFixedString to true and all will be well.

Sumar