Sumar
User
 Fresh Boarder
| Posts: 5 |   | Karma: 0 |
|
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
|
|